Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the following table with unit sales by product and by store summarized on a 4-weekly basis (4-4-5 scheme, 13 periods a year)
Now I would like to create a measure that calculates the difference between 'the sum of the last 13-Periods' and 'the sum of the periods ranging from last-14 till last-26'.
It would be great of course if I could also visualise evolutions from previous years and make it dynamic
Eg the difference between 'the sum of the periods ranging from last-14 till last-26' and 'the sum of the periods ranging from last-27 till last-39'.
And so on.
I'm completely new to Power BI so I have no idea if something like the above is possible and if my data is well structured to do this. Any help is highly appreciated 🙂
Bert
The table's layout makes it among the Best Router Table most portable tables you'll find, Router Table as well as while it may not be fancy.
Hi @bertjacobs,
Could you please mark the proper answer as solution?
Best Regards,
Dale
Hi Bert,
What is your original data? Based on your data here, you need a table like this:
Period compare_period
2014-p01 1
2014-p02 1
... 1
2014-p13 1
2015-p01 2
2015-p02 2
... 2
2015-p13 2
... ...
Then we can compare the amount by "compare_period".
Could you provide a dummy sample pbix file? At least a sample in text mode.
Best Regards,
Dale