This is my first post here. I was looking to get a better understanding of Power Query’s little known functions/ keywords such as _, each, try, and otherwise. I have seen try and otherwise used in error handling scenarios. Are there any other examples of where these are used ?
The power query code =#shared doesn’t list these mysterious functions. This makes me wonder if there are other useful little functions available
Not much video content I’m aware of but we’ve started a thread to bring some resources together. You can find that here. I would like to recommend to check out the video by Chris Webb (point 5) great introduction to M.
The underscore is a nameless variable in this context. If you create a calculated column within a table, you can use the underscore “_” to reference the current row of the table, which means the current record.