Forum Discussion
3 month rolling calculation error
Hi, I have a 2 data sources and need to do some operations between them. I have created a sample to represent the real life solution that I need. Table Sales: dateSold Sector Idsale NPS ...
Anonymous , You join it with the calendar table marked as date table and create measure like
example
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
Hi amitchandak, thank you for your reply!
Actually, there is no issue on calculating the rolling 3 period, the issue is on multiplying it by the respective weight of its Sector, like I'm trying to do in FinalValue field.
The rolling 3 is working fine, as done by the variables BAD, GOOD and TOTAL.