hi

[abc_777]

Hi,

could some one help me to calculate the following using DAX

Earned Point	Reedeem Point	Point Balance
2	0	0
3	0	0
5	2	8
7	0	15
2	4	13

thanks

[tamerj1 · Accepted solution]

Hi @abc_777 
Here is a sample file with the solutuion https://www.dropbox.com/t/cvHrJVgWHiu6ZPaf

First you need to add index column (if you have unique date or date/time column it also works just fine)

Then use the following code to create a new calculated column (let me know if you need measure instead)

Point Balance = 
VAR CurrentIndex = Data[Index]
VAR TableOnAndBefore = FILTER ( Data, Data[Index] <= CurrentIndex )
VAR EarnedPoints = SUMX ( TableOnAndBefore, Data[Earned Point] )
VAR RedeemedPoints = SUMX ( TableOnAndBefore, Data[Reedeem Point] )
RETURN
    IF ( 
        RedeemedPoints = 0,
        0,
        EarnedPoints - RedeemedPoints
    )

[abc_777]

greate thanks

[ribisht17]

@abc_777 

Question is not clear

Regards,

Ritesh