Forum Discussion
Solved
Calculate Movement between datasets from different dates
I have previously created a weekly sales report in excel - using pivot tables. I also created a static "movement" tab by copying and pasting the previous week's figures next to the current week, and...
I resolved this by setting up a reference table with the names of all the products and a reference date table.
I was then able to compare the 2 datasets from the different dates by liking the booking date to the date table and the product name to the product reference table.
v-chuncz-msft
Community Support
Community Support
You may take a good look at the following article.
https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
Thank you - I'll have a look.
- v-chuncz-msft
I resolved this by setting up a reference table with the names of all the products and a reference date table.
I was then able to compare the 2 datasets from the different dates by liking the booking date to the date table and the product name to the product reference table.