Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    5 years ago

    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)

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous sorry your question is not very clear, can you explain a bit more and also first two tables are identical?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 

     

    Thanks for the response. 

     

    The first two tables will have different data sets but the columns are the same. 

     

    I have imported two separate tables as above. Table one and Table Two. 

     

    I have inserted two new columns using the insert column option in powerbi. 

     

    I now want to merge these two tables into one. When I do this using the append and adding the two tables. The new columns I have added to not appear, only the columns of the original dataset that I originally uploaded.