hi

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

Need Help

tamerj1

4 years ago

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
    )

Forum Discussion

hi