Forum Discussion
Calculate Movement between datasets from different dates
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.
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.
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.
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.