Forum Discussion

mikemi's avatar
mikemi
Frequent Visitor
8 years ago

DAX relative date filtering

I am looking to create two relative date measures for the same field "Gross": Last 30 Days, and Quarter-To-Date. I created a quick measure but unsure how to filter for the two relative dates above. ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this measure

 

=CALCULATE(SUM('Opportunity'[Gross]),DATESBETWEEN(DateKey[Date],MIN(DateKey[Date])-30,MIN(DateKey[Date])))

 

Hope this helps.

yipioz's avatar
yipioz
Regular Visitor
6 years ago

Great measure ! Works for me as well 🙂 Thanks