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! Request now
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!
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!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 48 | |
| 46 |