Hi All,
I have a dataset and I want to generate the previous quarter results when I click on a current quarter.
For example - if in the filters for Dt(Quarters) I select 2019Q4 I should get value 15,503
I tried using the below but I am still getting the current value for the quarter selected in the filter.
{ FIXED DATEADD('quarter' , -1, [Dt]) : SUM([Amount])}
Any suggestions would be helpful.
Attaching the workbook for your kind review.
Regards,
Rishi Saka
Hi
filters remove data from the table so filtering will not work - you need to use a parameter to select the end quarter and then set you formulas up based on the parameter there are several ways to get YoY or Pop calculations - see https://jimdehner2.blogspot.com/2019/12/yoy-three-different-approaches.html for 3 - I would use the second - lods
Jim
