Forum Discussion
Table Import and Power Query Editor
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)
Thanks for the quick response.
First Option
I tried adding the new columns in Power Query but it doesn't allow me to do the following calculation as it doesn't allow to look up a different table:
UK Stores Units = LOOKUPVALUE('Q1 Location Split'[Percentage Split],'Q3 Location Split'[Country], "UK Stores")*Q1[Units])
Is there a way to look up a different table?
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)