Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

I neet to create a table from two tables

Hi all! I need to create a new table from two existing tables. First table ('Orders') I have a summarized table with delivery date, store number and orders (for each store and date)   Seco...
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, Anonymous 

    According to your description, I think you can use the “Merge query” in the Power query to left join the two tables with two external keys, you can follow my steps:

    1. Go to the Power query and merge a new query:

     

    1. Set the merge query like this:

    1. Then you can get the output table like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello Anonymous,

 

There is two ways.

 

First: you can add it as regular calculated column. So select table --> New column --> Name it and imput the formula.

 

Second you can add it to your DAX:
Just like this for example.

Hope this helps!