New column with the value of the last column with values

[Anonymous]

Hello everyone,  🙂

First, this is the structure of my table:

DATE_1	DATE_2	DATE_3
12/01/2020	12/05/2020
12/01/2020
12/05/2020		12/07/2020
12/05/2020	12/06/2020	12/08/2020
	12/08/2020

I would like to create a new column in that table, showing the date of the last column with values ​​in order (from left to right).
This is an example of what the new column should look like:

DATE_1	DATE_2	DATE_3	NEW_COLUMN
12/01/2020	12/05/2020		12/05/2020
12/01/2020			12/01/2020
12/05/2020		12/07/2020	12/07/2020
12/05/2020	12/06/2020	12/08/2020	12/08/2020
	12/08/2020		12/08/2020

Can someonde help me please?

[amitchandak · Accepted solution]

@Anonymous ,

Try like

max(Table[DATE_1],max(Table[DATE_2],Table[DATE_3]))

[Anonymous]

Thanks @amitchandak 
That was exactly what I wanted!! 🙂

[Mariusz]

Hi @Anonymous 

You can use COALESCE( )
https://docs.microsoft.com/en-us/dax/coalesce-function-dax

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn