Max of 2 Date Values

[Dowsey77]

Hi,

In Power Query I have a table with 2 date columns.  I use Table.TransformColumnTypes(#"Inserted Maximum",{{"Date1", type date}, {"Date2", type date}, {"Maximum", type date}}) in order to obtain the max of the 2 date values.  This seems to work in Power Query and I see the max of the 2 dates for each row in the table.  When I then apply this to Power BI, the max date then applies to the maximum of the 2 columns in their entirety and not for each row.  If I go back to "Transform Data" the maximum dates are definitely for each row, but this is lost when applying to Power BI.

Any ideas what I am doing wrong and/or how to obtain the max date for each row from 2 columns?

Thanks in advance,
Dowsey

[FreemanZ · Accepted solution]

in DAX, it is like:

Column = MAX( [Date1], [Date2] )

[amitchandak · Accepted solution]

@Dowsey77 , seem like @FreemanZ  already give DAX a solution, refer to that first. If that dos work, consider this 

Hope you have taken MAX before it

a new column

Maximum = List.Max({[Date1], [Date2]})

[FreemanZ · Accepted solution]

in DAX, it is like:

Column = MAX( [Date1], [Date2] )