DateDiff only works with measure and does not recognize columns

[patricPBI]

Hi, 

As many others here, I would like to get the count difference of two dates. 

I have one column called "closed dates" and another column called "Opened Dates"

When I try to do the "duration.day" formular in the query editor, the outcome only shows me errors. 

When I try to do a dax measure with DateDiff it only allows me to select measures from that data table, but not simple columns. 

My two date columns are categorized as "Date" so that cannot be the problem. 

Is there a way to use the DateDiff function with normal date columns?

[Pragati11]

Hi @patricPBI ,

Try a DAX measure something like this:

Diff = DATEDIFF(MAX(Date1), MAX(Date2), Month)

1. Modify MAX to other summarisation as required.
2. Replace Date1 and Date2 with your actual column names.

For details on DATEDIFF, refer following link:

https://docs.microsoft.com/en-us/dax/datediff-function-dax

Thanks,

Pragati

[patricPBI]

Hi @Pragati11 ,

UNfortunetely, I get the following error message:

Also, for MAX, it is asking me fo a Scalar 2. What do I have to input here?

Best regards,

Patric

[Pragati11]

HI @patricPBI ,

Unfortunately, just the screesnhot of your error doesn't help.

Share screesnshot of the measure you are writing.

Thanks,

Pragati

[patricPBI]

@Pragati11

What do I have to state where the "??" are?

[Pragati11]

Hello @patricPBI ,

The MAX function takes only one argument.

Check my DAX again.

Thank you

Pragati

[patricPBI]

HI @Pragati11

It tells me that I cannot have just one argument for he MAX function

[Pragati11 · Accepted solution]

Hi @patricPBI ,

You have got extra COMMA for MAX function. Remove them please as highlighted below:

Thanks,

Pragati

[patricPBI]

thanks a lot @Pragati11 

That was indeed the mistake.