Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I need to create a new column that has the minium date of 3 columns for each row in my table. I am trying to do this in power query. I tried each List.Min([column1], [column2], [column3]) but that errored. Message
Expression.Error: We cannot convert the value null to type List.
Details:
Value=
Type=Type
Some of the columns do have null values for all so I think I need to add argument before hand if all 3 columns are null then return null otherwise but not sure how to right that.
Thanks for any help.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!