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())
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,