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.
Hi,
How would in DAX calculate the number of days between 2 date columns
Wanted outcome (format: whole number): 2
Note: some Colum2 will be blank - here I would like a blank cell as outcome as well
Solved! Go to Solution.
Hi,
It seems this will work:
= IFERROR
(DATEDIFF(
table[column1],
table[column2],
DAY),
BLANK())
@Anonymous ,
Power Query
Duration.Days(Duration.From([Column2]-[Column1])))
In DAX
Try new column
Datediff([column1],[column2],day)
Wont work,
I alsso tried:
DATEDIFF
MIN( table[column1]),
MAX( table[column2]),
DAY)
@Anonymous , That is the measure .Hope your date setting is correct
Can you share a sample pbix after removing sensitive data.
Hi,
It seems the your link is about the date format and a slicer,
What i need is the date difference in days from 2 columns already formatted as date - as a DAX formula,
Hi,
It seems this will work:
= IFERROR
(DATEDIFF(
table[column1],
table[column2],
DAY),
BLANK())
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |