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 add an index column in power query as it is required to set the order for the day, after index column is added, apply the changes,
select day column and sort it by index and add the following measure
Measure =
VAR __d = MAX ( 'Day'[Index] )
RETURN CALCULATE ( PRODUCTX ( 'Day', [Value 1] ), ALLSELECTED ( 'Day' ), 'Day'[Index] <= __d )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, I had a similar problem. I am creating this recurring product, But encountering issue where the memory is full as its about 38k rows. Is there any way to come around this issue for a similar logical outcome?