Price variation between dates

[Anonymous]

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 · Accepted solution]

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.

[daXtreme]

Hi @Anonymous 

This seems to be a question related to Power Query, not DAX. Can you please post it on the right forum? Here it is: Power Query (powerbi.com)

Thanks.