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

[SP_1]

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.

[SP_1]

Need DAX code

[ribisht17]

Hi @SP_1 

Please check this https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-Calculation-Multiplying-V...

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 

[SP_1]

Hi @ribisht17 

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

Thanks

[Dangar332 · Accepted solution]

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

[SP_1]

Hi @Dangar332 
Thanks for the solution 

[talespin]

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)