Day on Day difference for each product

[pawelj795]

Hi,
I have a table like below with prices of my products.

Date	Product	Price
13.05.2021	A	5
13.05.2021	B	4
14.05.2021	A	8
14.05.2021	B	5
15.05.2021	A	6
15.05.2021	B	9

Now, I want to calculate the daily % difference between these prices for each product.
My desired result table should look like something like the below.

Thanks in advance for any help !

[Jihwan_Kim]

Hi, @pawelj795 

Please check the below picture and the sample pbix file's link down below.

I suggest having a dim-date table like below.

Price Measure = SUM('Table'[Price])

Day on Day Diff =

VAR previousdayprice =

CALCULATE ( [Price Measure], DATEADD ( Dates[Date], -1, DAY ) )

RETURN

DIVIDE ( [Price Measure], previousdayprice )

https://www.dropbox.com/s/kvqosm7b6ubhi0y/paweljv2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[pawelj795]

@Jihwan_Kim 
Thanks for weighing in.

You forgot to add -1 in your measure.

The difference for product A is 60%, not 160%.
Where add this -1 in your measure?

[Jihwan_Kim]

Hi, @pawelj795 

Thank you for your feedback.

Please check the below.

Day on Day Diff =

VAR previousdayprice =

CALCULATE ( [Price Measure], DATEADD ( Dates[Date], -1, DAY ) )

RETURN

IF(not ISBLANK([Price Measure]),

DIVIDE ( [Price Measure]-previousdayprice, previousdayprice )

)

https://www.dropbox.com/s/kvqosm7b6ubhi0y/paweljv2.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[pawelj795]

@Jihwan_Kim 
I need to modify your measure slightly.
I want to show only products, which price changed yesterday (or the current week).

This could be a simple table.

Product	% Difference change (yesterday)	Price before	Price after
A	80%	10	18
B	70%	10	17
C	60%	10	16
D	50%	10	15

[Jihwan_Kim]

Hi, @pawelj795 

Is the above input or output?

Seeing above, A / B / C / D all products have changes in the price.

[pawelj795]

@Jihwan_Kim 
It is the output.

This table must show only products, which prices changed yesterday. (it is another table to the one you help me created before)

[pawelj795]

Thanks, it's working!
Now, I want to add another measure, which shows only products, which prices changed yesterday, a current week, etc. How to do that?

[pawelj795]

@Jihwan_Kim 

.

[Jihwan_Kim]

@pawelj795 

I cannot understand your question.

Share your idea ( or drawing of the table) about how your desired outcome looks like.