Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @isabel_herrero0 ,
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.
Hi @isabel_herrero0 ,
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.
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.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |