Hi, How would in DAX calculate the number of days between 2 date columnsColumn1 (format: date): 17-11-2016Column2 (format: date): 19-11-2016Wanted outcome (format: whole number): 2 Note: some Colum2 will be blank - here I would like a blank cell as outcome as well

Hi,It seems this will work: = IFERROR (DATEDIFF( table[column1], table[column2], DAY), BLANK())

Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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