topic Re: DAX Calculation based on Previous Row in DAX Commands and Tips

DAX Calculation based on Previous Row

Anonymous — Wed, 02 Nov 2022 14:25:14 GMT

I have a dataset of columns (Index & Step 1)

I am trying to achieve the below calculations for Step 2 and Final

Any suggestions? Thanks

Re: DAX Calculation based on Previous Row

tamerj1 — Wed, 02 Nov 2022 19:36:35 GMT

Hi Anonymous
Please refer to attached sample file with the solution

Step 2 = VAR CurrentIndex = 'Table'[Index] VAR TableBefore = FILTER ( 'Table', 'Table'[Index] < CurrentIndex ) VAR P1 = COUNTROWS ( TableBefore ) + 1 RETURN SUMX ( TableBefore, VAR X = 'Table'[Step 1] VAR P = P1 - 'Table'[Index] RETURN ( 0.5 ) ^ P * x )

Step 3 = 'Table'[Step 1] + 'Table'[Step 2]

Re: DAX Calculation based on Previous Row

Anonymous — Thu, 03 Nov 2022 12:56:00 GMT

tamerj1 Thank you! This works like magic! thanks alot 🙂

Re: DAX Calculation based on Previous Row

Anonymous — Thu, 03 Nov 2022 12:59:09 GMT

tamerj1 I attempted to replace the index row value from the matrix to Month-Year column (Sept 2022, Oct 2022, ...) - Now the numbers are not accurate, does this only work with index?

Re: DAX Calculation based on Previous Row

tamerj1 — Thu, 03 Nov 2022 14:44:19 GMT

Anonymous

It has to be of integer data or date (unique date) type.