Forum Discussion
MarcosGabriel
3 years agoNew Member
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...
- 3 years ago
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
Ritaf1983
3 years agoSuper User
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
- MarcosGabriel3 years agoNew Member
Hi, Ritaf1983!
I did what you told me, and it worked very well! Thank you for helping me with this and for your desire to help!- Ritaf19833 years agoSuper User
Glad to help ☺️