This content has been marked as final. Show 2 replies
I would like to create a KPI like table showing Absolute Week over Week Change, Week over Week % Change, Month over Month % Change, and Year over Year % Change. Similar to the following but with the measures I just listed replacing the ones shown in my view:
I would like the measures to calculate on the last day shown in the Order Date Filter (in this case 12/31/2014). So my first measure would be Avg Sales, but only for 12/31/2014. The next measure would be the Absolute Week over Week Change of Avg Sales on 12/31/2014 - Avg Sales on 12/24/2014, etc...