Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |