Forum Discussion

Guille2711410's avatar
Guille2711410
Icon for Helper I rankHelper I
6 years ago

CALCULATE between dates and parameters

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]...
SteveCampbell's avatar
SteveCampbell
Icon for Memorable Member rankMemorable Member
6 years ago

try:

 

Accum_90days = 
var _cutoff = [CutDate]

RETURN

CALCULATE (
   [M_Value], 
   DATESBETWEEN (Calendar [Date], 
      _cutoff - 90, 
      _cutoff
     )
)
  • Guille2711410's avatar
    Guille2711410
    Icon for Helper I rankHelper I
    6 years ago

    Thanks Steve

    My cut-off date 08/31/2020

    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.

    Thank you very much

    • Guille2711410's avatar
      Guille2711410
      Icon for Helper I rankHelper I
      6 years ago

      I tried your solution Steve but it did not work, I ask for assistance again with more information, I await a response. Thank you