Forum Discussion
Table Import and Power Query Editor
Hi there, I have imported three tables of data: Table One Vendor Product Code Type Year Quarter Units Plastic Weight Steel Weight Inserted column via power bi new colum Ins...
Power Query doesn't use DAX language, it uses M.
Yes, there are ways to look up other tables via Table Merge or M but if this is all new to you why don't you append the tables first and add calculated columns in DAX after. (If this makes sense in your data model)
If you link the pbix here, I'm sure this can be sorted quite quickly.
It does suggest that the 'Append' query is referring to the tables in an earlier form