topic Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi in DAX Commands and Tips

Need help on DAX measure on running multiplication value from Previous row value - Power bi

SP_1 — Sat, 10 Feb 2024 06:22:11 GMT

Hi,
Power BI
Need help on creating measure on running multiplication value from Previous value
Using Date hirerachy ( Year -> Month in my Power BI table visual)
below is the sample screen shot as output.

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

SP_1 — Sat, 10 Feb 2024 06:18:27 GMT

Need DAX code

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

ribisht17 — Sat, 10 Feb 2024 06:34:54 GMT

Hi SP_1

Please check this https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-Calculation-Multiplying-Values-from-Previous-Row/td-p/2939002

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

SP_1 — Sat, 10 Feb 2024 06:41:16 GMT

Hi ribisht17

I already tried but its not working for date hierarchy (Year / Month)

Thanks

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

Dangar332 — Sun, 11 Feb 2024 16:56:28 GMT

Hi, SP_1

you need month number column in your table
try below measure

Measure 4 = PRODUCTX( FILTER( ALL('Table (2)'), 'Table (2)'[year]=MAX('Table (2)'[year]) && 'Table (2)'[month number]<=MAX('Table (2)'[month number]) ), 'Table (2)'[value] )

and change decimal number of measure to 5

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

talespin — Mon, 12 Feb 2024 00:45:02 GMT

hi SP_1

Another method, I have used Date table(Calendar) and Fact table(ProductTbl), linked one to many relationship. To sort the results I have also added YearMonth to table but changed font color to white so it is not visible, MonthYear or date is needed to show results sorted, if sort is not required, you can skip this step.

MProductTest =

VAR _SelYr = SELECTEDVALUE('CALENDAR'[YEAR])

VAR _SelMth = SELECTEDVALUE('CALENDAR'[MonthNo])

VAR _Dt = DATE(_SelYr, _SelMth, 1)

VAR _Product = CALCULATE(PRODUCT(ProductTbl[Value]), REMOVEFILTERS(ProductTbl[Value]), 'CALENDAR'[Date] <= _Dt)

RETURN IF( ISBLANK( MAX(ProductTbl[CapDate]) ), BLANK(), _Product)

Re: Need help on DAX measure on running multiplication value from Previous row value - Power bi

SP_1 — Mon, 12 Feb 2024 14:42:07 GMT

Hi Dangar332
Thanks for the solution