Learn About Power Query Formulas. Generally the last query step is used as the in final data set result. Power Query makes it very fast and easy to merge two tables together with just a few clicks.
You will get the documentation as well This is useful when you write your own Power Query formulas and need more info about the function that the intellisense gives you. But you can start by trying to change the formula in this waythe reference to other table is missing probably. For instance if we want to use the Excels FIND function to find a specific character in the text it is not supported in M.
It basically uses SQL joins so you can even do more advanced merges like inner outer left right full and anti joins.
Generally the last query step is used as the in final data set result. You will get the documentation as well This is useful when you write your own Power Query formulas and need more info about the function that the intellisense gives you. And complete it without parenthesis. Power Query on the other hand starts.
