Forum Discussion
week over week change 2 date dimensions
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
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.
1 Reply
- amitchandak
Super User
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.