Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I am facing this challenge and I'm not sure how to approach it.
I have to forecast the nr of incoming cases and my seasonality is affected by some fixed periods (like Christmas) and some variable periods (like eastern).
Due to this, comparing using for instance SAMEPERIODLASTYEAR would work for the fixed periods but not for others like eastern that every year occurs on different dates.
I have already created on my calendar a column defining these periods for past and future dates.
I'm probably not the first one that has faced a similar situation and I was wondering if somebody could give me a hint on how to tackle this.
Thanks in advance
Solved! Go to Solution.
Try using CALCULATE Function to change the context.
Try using CALCULATE Function to change the context.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |