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.⚡
Hi All,
I have a Date in the model so I believe that should work instead of an index column. However, how to I add a filter to have it start caclulating on a certain date. Both of the ways you suggested are resulting in a 0 value which I suspect might be becuase the very first value is a 0. Therefore, multiplying anything by 0 = 0. I tried adding a second filter 'Values[DATE] > "12/31/2016" and also Values[DATE] > 42735 but it doesn't seem to work. How can I add a second filter?
On another note, why do some components of measures in Power BI turn purple? As in the formula bar text becomes purple? What does that mean?
Thank you very much
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.⚡
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!
