Dax help with getting difference between 3 dates

[Anonymous]

Hello, 

I am currently building a dashboard and having trouble creating an expression computing the difference between dates. 

This issue is there are three dates to account for 

The Created date 

The Due Date

The Negotiated Due Date.

In my scenario I need an expression to compute the time lapsed between the Created date and the Negotiated due date UNLESS the negotiated due date is null, then instead I need the difference between the created date and the Due Date.

Any help would be greatly appreciated! 

[barritown]

Hi @Anonymous,

I guess you need a calculated column like this:

In plain text:

Difference Calculated Column = 
DATEDIFF ( [Created Date], IF ( ISBLANK ( [Negotiated Due Date] ), [Due Date], [Negotiated Due Date] ), DAY )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian