Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi all:
I'm grabbing the 2nd value from a list within Power query using the following code:
#"2nd Recent Order" = Table.AddColumn(#"Found Most Recent Order", "2nd Latest Order", each [Order]{1})As expected, I'm getting Errors for all rows in which there is only 1 Order (ie. no row [Order]{1}). That's not a problem. What is the best way to resolve these errors and replace with blanks/nulls?
Thanks!
Solved! Go to Solution.
#"2nd Recent Order" = Table.AddColumn(#"Found Most Recent Order", "2nd Latest Order", each try [Order]{1} otherwise null )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
#"2nd Recent Order" = Table.AddColumn(#"Found Most Recent Order", "2nd Latest Order", each try [Order]{1} otherwise null )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Merci!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.