Forum Discussion

MarcosGabriel's avatar
MarcosGabriel
New Member
3 years ago
Solved

Calculate the difference between many values from the same date based on a condition

What's up, everybody!? How are you doing? Hope you're doing very well!   I recently started learning Power BI to add more value to my work at the company I'm currently working in. I want to perform...
  • Ritaf1983's avatar
    3 years ago

    Hi MarcosGabriel 

    You can create a measure using dax :

    balance = CALCULATE(SUM('Table'[value]),'Table'[Situation]="paid")- CALCULATE(SUM('Table'[value]),'Table'[Situation]="unpaid")
     

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