Forum Discussion
Solved
Calculating the difference in days between two dates
I have a start date calculated as a measure and I am wanting to subtract it from "Today()" date. See image below, the first line item has a start date of 4/21/2022 and the Age (days) is 4,734 [Today'...
Use datediff instead
DATEDIFF('table'[start date], today(), days)There's a start of month function you might be able to use!
STARTOFMONTH function (DAX) - DAX | Microsoft Docs
Ok - so I created this Date Key
And I have the following formula:
Age (Days) = DATEDIFF('Service 4 - Contract accts'[Start date],STARTOFMONTH('Date key'[Date]),DAY)
but now my days in the able for the example is (-)
I was able to get the correct days to flow through by ONLY putting the month I am referencing in the Date key. Is there anyway to put all months in the key and point to the current month? to eliminate having to refresh that date every time?