cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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], 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.

Calendar [Date]> CUT DATE

How can I do. I will appreciate your comments.

Regards

3 REPLIES 3
Highlighted
Super User I
Super User I

try:

 

Accum_90days = 
var _cutoff = [CutDate]

RETURN

CALCULATE (
   [M_Value], 
   DATESBETWEEN (Calendar [Date], 
      _cutoff - 90, 
      _cutoff
     )
)


Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Highlighted

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

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors