How to subtract previous value for below screenshot

[Ranga_naik]

Hi team,

I am trying to  subtract  current  value with previous value with dax measure not able to acheieve  it 

example

for the  user abhinsp  6-6 = 0 

arung = 19-20

Regards,

Ranga Naik

[lbendlin · Accepted solution]

use the PREVIOUS  visual calculation with the COLUMNS modifier.

[v-dineshya]

Hi @Ranga_naik ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks

[v-vpabbu]

Hi @Ranga_naik,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @Ranga_naik,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[v-vpabbu · Accepted solution]

Hi @Ranga_naik 

Thank you for reaching out to Microsoft Fabric Community Forum

As per your query, I have created Calculation (It will subtract current value to previous value)

Here is the Dax Query:   Calculation = [Sum of 202408]-[Sum of 202407]

For Referene:

Refer this Document for using Visual Calculation

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[lbendlin]

Please define what you mean by "previous".  

Do you want to use regular DAX or Visual Calculations?

[Ranga_naik]

Looking for visual calculation 

[Ranga_naik]

I am looking Visual calculation 

[lbendlin · Accepted solution]

use the PREVIOUS  visual calculation with the COLUMNS modifier.