Forum Discussion
Dax help with getting difference between 3 dates
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!
1 Reply
- barritown
Solution Sage
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
