Forum Discussion
Min Dates (mutiple Columns) Power Query - possible blank values
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? SuccessDateToUse = VAR _remoteRental = IF(ISBLAN...
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 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]}))