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.

2 Replies

  • selinaz's avatar
    selinaz
    Resolver 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.