Forum Discussion
Cumulative Multiplication measure
ARob198 not sure what you are referring to purple, share screenshot, here is how you can add 2nd filter
Measure = VAR __d = MAX ( 'Day'[Index] ) RETURN CALCULATE ( PRODUCTX ( 'Day', [Value 1] ), ALLSELECTED ( 'Day' ), 'Day'[Index] <= __d, 'Date'[Date] > DATE(2016,1,1) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
ARob198 not sure what you are referring to purple, share screenshot, here is how you can add 2nd filter
Measure =
VAR __d = MAX ( 'Day'[Index] )
RETURN CALCULATE ( PRODUCTX ( 'Day', [Value 1] ),
ALLSELECTED ( 'Day' ), 'Day'[Index] <= __d, 'Date'[Date] > DATE(2016,1,1) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Thank you. Here is a screenshot of the purple text and my formula. It doesn't seem to be working for me, I am not sure why. The MTD INT calculation is working so I just need it the ITD to be a cumulative multiplied table on this number. What the best way to trouble shoot this?
ARob198 that shows it is a measure.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡