Forum Discussion
Solved
Dax Formula Between Dates
Hi, I need to fix this formula. It doesn´t work. YTD MTD Actual Cost = CALCULATE([Actual Cost], // Sum Amount VAR FirstFiscalMonth = 9 -- Set the first month of the fiscal year VAR LastDa...
Hi,
Try this measure
Measure1 = CALCULATE([Actual Cost],DATESBETWEEN('Calendar'[Date],IF(MONTH(TODAY())>=9,DATE(YEAR(TODAY()),9,1),DATE(YEAR(TODAY())-1,9,1)),IF(MONTH(TODAY())=9,TODAY(),EDATE(TODAY(),-1))))
Hope this helps.
Hi,
Try this measure
Actual Cost since inception = CALCULATE([Actual Cost],DATESBETWEEN('List Period'[Date],MINX(ALL('Calendar'[Date]),'Calendar'[Date]),IF(MONTH(TODAY())=9,TODAY(),EDATE(TODAY(),-1))))
Hope this helps.
Hi Ashish_Mathur ,
Works perfect ! I was trying to find this measure long time ago :) Thanks a lot !!
Best Regards !:)
You are welcome.