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)
Morning,
Thanks for the response. My organisation prevents from using links to allow me to share the pbix. I will take some screenshots below:
Q1
Q2
The last three columns in the above tables are a calculation I completed in powerbi.
I then go to the edit queries and the Power Query Editor opens.
The final three columns in the above table do not appear when I open them in the Power Query Editor:
Is there a reason why I cannot see the three columns that I inserted?
These columns have a calculation which looks up another table:
The new columns have been added with DAX in Powerbi front end. Power Query doesn't know anything about them.
Options:
Add the New columns in Power Query and Append the tables OR
Append the tables in Power Query and add the columns (using DAX) to the final table
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)