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,
Below i have a DAX function giving me the min. value of mutiple date values (columns). Does anyone know how to do this in PowerQuery?
Solved! Go to Solution.
A slight adjustment to AIB's formula should do it. Sub in your column names (should all be Date type)
Table.AddColumn(#"Changed Type", "Custom", each List.Min({[rSales] , [rRental] , [PRental] , [PSale]}))
Hi @Anonymous
You could make one list of all four columns and then extract the minimum. Something like
List.Min(Table1[Col1] & Table1[Col2] & Table1[Col3] & Table1[Col4]))
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @AlB ,
When i do this i get the following error
--> I think because for some values are "null"
Expression.Error: We cannot convert Type to List type.
Details:
Value=[Type]
Type=[Type]
A slight adjustment to AIB's formula should do it. Sub in your column names (should all be Date type)
Table.AddColumn(#"Changed Type", "Custom", each List.Min({[rSales] , [rRental] , [PRental] , [PSale]}))
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.