Hi guys,
I have a fact table with account balances and a dim date that contains date and previous quarter end for each date.
Both tables contain info about working days only.
I would like to prepare a report that returns the % variance QtD of the accounts balance sum based on the date selected in a slicer.
For example the sum of the balances is 12 usd on 5 Apr 2019, the sum of the balances is 10 usd on 29 Mar 2019 (end of previous Q) and the report should return 20%.
If I change the slicer value to 4 Apr then the report should compare the sum from 4 Apr to the sum of 29 Mar. Consequently if I choose 12 Jul 2019 it should compare with 30 Jun.
How can I achieve this please?
Many thanks,
Sabin