IF Function -

[jeoosma]

Hi guy. I've to calculate the difference between two date (which are in the same table) but if one is blank I want to use today.

I write the function so:

if isblank([RechDatum]) then now() - [Eingangsdatum] else 0

but it doesn't work, gives me error.

How can I resolve? Thank you.

Max.

[jeoosma]

Sorry, the sintax DAX can be used also in power query of Excel?

[Kasunpathirana · Accepted solution]

You can use below two step method 

Create a new column

Column = If(Table1[Date 2] = BLANK(),TODAY(),Table1[Date 2])

Then Date Difference you can calculate as below

DATEDIFF = DATEDIFF(Table1[Date 1],Table1[Column],DAY)

Please let me know if this helps 

[jeoosma]

Thank you as soon as possible I'll use the function