Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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()
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()
This is not working when connection live and using the direct query option.
How'll don in case of directquery.
Thanks,Umesh
Thanks. This work for me. I see the Power Pivot method, and I don't like. Blessings!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |