Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |