min and max of each row between dates - Power BI

[JohnJairoV]

Hi, to all!

This time I want to calculate the min (and max) of each row between dates (dd-mm-yyyy format)

Date 1	Date 2	Date 3	Min Result	Max Result
04/05/2017	16/02/2017	20/09/2016	20/09/2016	04/05/2017
null	null	null	null	null
09/02/2017	null	05/08/2016	05/08/2016	09/02/2017
25/05/2016	10/08/2017	19/12/2016	25/05/2016	10/08/2017
null	06/07/2017	null	06/07/2017	06/07/2017
04/08/2017	15/09/2016	20/04/2017	15/09/2016	04/08/2017
16/07/2017	null	04/06/2016	04/06/2016	16/07/2017

The columns Date 1, Date 2, Date 3 are non-contiguous (if is important to know) and I have another columns between the date's column.  Where is easiest to calculate? in PowerQuery?, in PowerPivot?, how can I calculate the desire results?

In Excel is really easy to calculate.  I don't find the easy way.

Thx in advanced for your answers.  Blessings!

[TomMartens · Accepted solution]

I would do this in PowerQuery.

Create a custom column with the following formula:

List.Min({[Date1],[Date2],[Date3]})

Beware the braces, that convert the column values into a list whereas the function returns the Minimum Value from the list. For the Maximum value use List.Max()

[umeshjss]

This is not working when connection live and using the direct query option.

How'll don in case of directquery.

Thanks,Umesh

[JohnJairoV]

Thanks.  This work for me.  I see the Power Pivot method, and I don't like.  Blessings!