Forum Discussion
abc_777
Solution Specialist
4 years agohi
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
- 4 years ago
Hi abc_777
Here is a sample file with the solutuion https://www.dropbox.com/t/cvHrJVgWHiu6ZPafFirst 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 )
tamerj1
Community Champion
4 years agoHi 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_7774 years ago
Solution Specialist
greate thanks