Lookup Function Creation?
1. In general we are using lookup function for the Comparison purpose,. Like Year over Year comparison based on the sales.
2. Drag Order Date into Rows.
3. Create calculation for Lookup function for previous year, as shown below.
6. In that select sort Type as Ascending order and give the Sorting manually, as shown below.
8. Now drag the measure values into Text at marks card level.
9. Measure values are shown below the marks cards. In that right click on the YOY sales Growth and select ‘add table calculation’ and select the fields as shown below.