Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
We have 3,3,3,4 calendar with 13 periods.
Sales are reported on periodic level.
I have connected fact table Sales and Date table via 'starting day of the period' connects to 'day' in Date table.
I have index number for periods like '2017 Period 1' is '1' , .. , '2017 Period 12' is '12' and '2017 Period 13' is '13',
'2018 Period 1' is '14' , .. , '2018 Period 12' is '25' and '2018 Period 13' is '26'.
What I would like to know is, how to get sales from the previous fiscal period?
We have now selected 'Period 12', that is from 4.11. to 1.12.
How do I see sales in 'Period 11', that is from 7.10. to 3.11?
And how do I see sales in 'Period 11' a year ago?
Thank you!
Solved! Go to Solution.
@Anonymous,
Try using CALCULATE Function to change the context.
@Anonymous,
Try using CALCULATE Function to change the context.