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.
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 calculating the difference by using a straight forward excel calculation in the static data.
I am trying to recreate this in PowerBI.
I have 2 datasets - one from 14th Dec and one from 21st Dec.
The datasets are exactly the same - just pulled on different dates.
I have also created a DateKey table.
I need to show:
YTD 2016 as at 14th Dec vx YTD 2017 as at 14th Dec
YTD 2016 as at 21st Dec vx YTD 2017 as at 21st Dec
I ALSO need to show:
Movement from 14th - 21st 2016
Movement from 14th - 21st 2017
I've tried variance and difference and subtraction quick measures but none are returning the correct figures.
I'm not sure how to establish the correct relationships between the 14th and 21st Datasets.
Any advice very welcome!!
Solved! Go to Solution.
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.
Any progress, feel free to share with us.
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.
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 calculating the difference by using a straight forward excel calculation in the static data.
I am trying to recreate this in PowerBI.
I have 2 datasets - one from 14th Dec and one from 21st Dec.
The datasets are exactly the same - just pulled on different dates.
I have also created a DateKey table.
I need to show:
YTD 2016 as at 14th Dec vx YTD 2017 as at 14th Dec
YTD 2016 as at 21st Dec vx YTD 2017 as at 21st Dec
I ALSO need to show:
Movement from 14th - 21st 2016
Movement from 14th - 21st 2017
I've tried variance and difference and subtraction quick measures but none are returning the correct figures.
I'm not sure how to establish the correct relationships between the 14th and 21st Datasets.
Any advice very welcome!!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |