Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Price variation between dates

Hi,   Im traing to calculate the price variation between two dates.      Is just a rest but i dont know how to do it.   Thank you
  • selinaz's avatar
    selinaz
    4 years ago

    Hi Anonymous ，

     

    please check this result:

    If it is what you want , you can try to create a new column 

    and the sytnax is as the following writes:

    Variation = DIVIDE(([Brent] - MAXX(FILTER('Table', 'Table'[Date]=EARLIER('Table'[Date])-1),[Brent])),[Brent])

     then you can get the variation between two dates, notice that you can change the format of data to percentages:

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    Best regards.

selinaz's avatar
selinaz
Icon for Resolver II rankResolver II
4 years ago

Hi Anonymous ，

 

please check this result:

If it is what you want , you can try to create a new column 

and the sytnax is as the following writes:

Variation = DIVIDE(([Brent] - MAXX(FILTER('Table', 'Table'[Date]=EARLIER('Table'[Date])-1),[Brent])),[Brent])

 then you can get the variation between two dates, notice that you can change the format of data to percentages:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Best regards.