Forum Discussion
Solved
Add 3 Month to MIN Date
Hi all, I have an issue with my DAX formula. I want to compare to dates in a matrix using a dates filter (Quarters and Year): I almost solved this by using the following two formulas. Fi...
Hi,
Not sure of what you want but try this
Min_value = CALCULATE(SUM('Totals'[Value]),DATESBETWEEN('Date'[Date],EDATE(MIN('Date'[Date]),3),EDATE(MIN('Date'[Date]),3)))
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Not sure of what you want but try this
Min_value = CALCULATE(SUM('Totals'[Value]),DATESBETWEEN('Date'[Date],EDATE(MIN('Date'[Date]),3),EDATE(MIN('Date'[Date]),3)))
Hope this helps.
Thanks a lot! That solved my problem!
- Ashish_Mathur
You are welcome.