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.⚡
The formula is giving me 0s. Even though my data has values for the columns to be multiplied- as in the post above. The MTD Int is the value that I need to use for the cumulative multiplication. Any thoughts on how to get this to work or even to trouble shoot this? Thank you
@ARob198 Hello, did you solve this problem?
At this point I get into the same problem that you pose I want to do a cumulative multiplication but all the values appear to me in 0.
I'd appreciate it if you help me, thanks!
