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.
Hello,
Im lookin to monitor forecast changes on a per SKU level on a week to week basis. We create a forecast every week for 12 month period like this one:
My plan is to have something like this in a waterfall format so that we can see the changes against the previos week on a monthly basis, similar to how its shown bellow:
My plan is to use dax for this measure as seen in other post but due to it having two date tables(onr a calendar table , the othe a report reference date table), im having trouble creating it
anybody have any pointers on where shoid i start?
thanks
Solved! Go to Solution.
I am not sure I got it completely. But please Check the Article. Two ways to use multiple date filter. For second one link is given in Article.
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
Appreciate your Kudos. In case, this is the solution you are looking for, mark it at Solution.
Thanks.
I am not sure I got it completely. But please Check the Article. Two ways to use multiple date filter. For second one link is given in Article.
https://medium.com/chandakamit/power-bi-comparing-data-across-date-ranges-36be49b68613
Appreciate your Kudos. In case, this is the solution you are looking for, mark it at Solution.
Thanks.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |