Hello I want to calculate a value between 90, 120, 150 and 180 days. I use the following DAX formula: For example for 90 days it is: Accum_90days = CALCULATE ([M_Value], DATESBETWEEN (Calendar [Date], date (2020,9,30), date (2020,11,30)))
However, I want to change the fixed dates to dynamic dates and that those dates are always greater than my cutoff date of the data DATE CUT.
I want to calculate the value in the next 90,120,150 and 180 days from the first day of the following month, in this case 09/01/2020 and from there accumulate the value for the next 90 days 11/30/2020.
Also if there would be the possibility of handling the number of days in the same formula.