Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
5 years ago

Day on Day difference for each product

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.20...
Need Help
Show and Tell
Tips and Tricks
pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
5 years ago

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's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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 )
)
 
 
 

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's avatar
    pawelj795
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    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?

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        5 years ago

        pawelj795 

        I cannot understand your question.

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

  • pawelj795's avatar
    pawelj795
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    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 beforePrice after

    A

    		80%1018
    B70%1017
    C60%1016
    D50%1015

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Hi, pawelj795 

      Is the above input or output?

       

       

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

      • pawelj795's avatar
        pawelj795
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        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)