Measure with % differences between weeks

[Anonymous]

Hi colleagues!

I am quite new with Power Bi and I cannot solve the problem with creating a measure/column with % difference between planning weeks.

Details:

I am creating demand changes report in Power Bi and one visualization should show in what % demand for accurate week in the year are changing between planning weeks.

The source looks like this:

The source is updating every day with the most fresh data and do not remove old data due to fact that we need also historical data, so to create measure with the numbers which should be shown in the visualization I took the last import date from each planning week and data what have the same date in import and delivery date (it is my assumtion that I sold this parts and it's also our effect for demand changes).

First visualization what I've created looks like this:

Where 1 is week plan and 2 is week delivery. So for exaple I see that in 19th week I planned that in 20th week I will sale 174 563 pieces, and in 20th week I changed the numbers to 183 137 pieces. 

In second visualization I want to show that when the first demand appears - it is always 100% because it is our base, and next planning weeks should shown the differences in %.

Example for delivery week 21st:

	delivery
	%	numbers
Planning	21-2022
19-2022	100%	203 798,00
20-2022	-0,61%	202 548,00
21-2022	-31,96%	137 410,00

Any ideas?

Thanks!

[Anonymous]

HI @Anonymous,

These fiscal periods does not suitable to write dynamic conditions to calculate. I'd like to suggest you extract the current date value and use them to get the previous date value.
Then you can use these values to find out the corresponding fiscal periods and use them as conditions to calculate.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @v-shex-msft ,

thanks! Can you please let me know how to do it in the right way? 

I was thinking also to do it with the indexes - first plan week is index no. 1 etc.

Regards,

Joanna