Forum Discussion

amiller5's avatar
amiller5
Helper II
4 years ago
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'...
Need Help
Syk's avatar
Syk
Resident Rockstar
4 years ago

Use datediff instead

DATEDIFF('table'[start date], today(), days)
  • amiller5's avatar
    amiller5
    Helper II
    4 years ago

    Is there a calculation for an "as of" date? Similar to the equation you supplied above, instead of TODAY(), is there something to make it calculate off of as of first of current month?