Returning todays date if other conditions are not met

[Kelz0484]

Hi,

I have a dashboard with 2 date columns. 

Column A is a end date and column B is an extension date. I need a latest date column added with the following conditions:

If End date is > extension date then use end date,

If extension date is >= end date then use extension date else use todays date.

Note: Todays date would be used if both columns A&B were empty. 

I currently have the below If statement:

Latest Date = if[Extension Date]>=[End Date],[Extension Date],if[End Date]>[Extension Date],[End Date],today()))

But it isn't giving me today's date in the outcome its leaving blank cells.

Hope this makes sense

Any help appreciated

Thanks!

[Martin_D · Accepted solution]

Hi @Kelz0484 ,
if[Extension Date]>=[End Date] is ture in case both columns are blank, then your formula returns [Extension Date] which is blank.
This formula should do the job:

COALESCE ( MAXX ( { 'Table'[End Date], 'Table'[Extension Date] }, [Value] ), TODAY() )

[Kelz0484]

Brilliant. Works a treat! Thank you so much.