Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
143 | |
111 | |
108 | |
99 | |
95 |