Cumulative Calculation Multiplying Values from Previous Row
Hello, I need to create a cumulative measure that references the previous rows values like this: Where refPeriod comes from the dim table Periods, allItemsByItem comes from the fact table I_data and value comes from another fact table W_data. The relationships between tables are as follows: Periods[refPeriod] = I_data[refPeriod] 1 to many single direction Periods[basketYear] = W_data[basketYear] many to many bi-directional There is no relationship between I_data and W_data Slicers for product, geography, start refPeriod and end refPeriod are used to bring the results into a table visual. I can identify the first selected reference period with if(min('Periods'[refPeriod]) = selStartDate, value..... where selStartDate is a measure that captures the value from one of my date slicers. The problem is how to figure out the calculation after the first row. First row logic: = value from the same row. All other row logic: = the result of the measure in the previous row multiplied by the allItemsByItem in the previous row. Any suggestions would be greatly appreciated. And I can provide more information if it's needed.
