Forum Discussion
Power Query Editor: Calcualte Date difference (some columns blank)
Hi, How would in DAX calculate the number of days between 2 date columns Column1 (format: date): 17-11-2016 Column2 (format: date): 19-11-2016 Wanted outcome (format: whole number): 2 No...
Hi,
It seems this will work:= IFERROR (DATEDIFF( table[column1], table[column2], DAY), BLANK())
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())