Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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's date is 6/1/2022). Not sure why it is so off?
Age (days) is a calculated column
Solved! Go to Solution.
There's a start of month function you might be able to use!
STARTOFMONTH function (DAX) - DAX | Microsoft Docs
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:
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?
Age in days Measure =
DATEDIFF (
MIN ( Mytable[Start Date] ),
TODAY (),
DAY
)
INT(
MIN ( Mytable[Start Date] ) - Today()
)
Use datediff instead
DATEDIFF('table'[start date], today(), days)
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |