Problem with NULL values in a measure for DATEDIFF

[mwitt2]

Hi,

Total nebie and not a developer, have done extensive googling as well as searching the forum here to no avail, but here we go;

I´m trying to create a measure for DATEDIFF between two columns containing timestamps in the same table, but it´s failing and it seems to be based on some rows containing NULL-values.

The statement is simple:

Measure = DATEDIFF(TABLE[column],TABLE[column], HOUR))

Is there a way to filter out the rows containig NULL values directly in the query?

Br

/Micke

[mwitt2]

Thanks amitchandak, this solved my issue, great!!!

Br

/Micke

[amitchandak · Accepted solution]

@mwitt2 , Try a new column like

Measure = if(not(isblank([column1])) && not(isblank([column2])) , DATEDIFF(TABLE[column1],TABLE[column2], HOUR) , blank())