Power Query Editor: Calcualte Date difference (some columns blank)

[Anonymous]

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

Note: some Colum2 will be blank - here I would like a blank cell as outcome as well

[amitchandak]

@Anonymous ,

Power Query

Duration.Days(Duration.From([Column2]-[Column1])))

In DAX

Try new column

Datediff([column1],[column2],day)

[Anonymous]

Wont work,

I alsso tried:

DATEDIFF
MIN( table[column1]),
MAX( table[column2]),
DAY)

[amitchandak]

@Anonymous , That is the measure .Hope your date setting is correct

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Can you share a sample pbix after removing sensitive data.

[Anonymous]

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,

[Anonymous · Accepted solution]

Hi,

It seems this will work:

= IFERROR
(DATEDIFF(
table[column1],
table[column2],
DAY),
BLANK())