I need help creating a table which contains columns from different data source

[realme1]

I have the column SKU same in all the data sources, and I need add a table where I have SKU, Sell thru units, weeks, sell thru values. The key is SKU which is relating all the different data souces. Need the DAX for that table, do I use SUMX, Summarize or what?  

[Anonymous · Accepted solution]

Hi  @realme1 ,

I created some data:

Table1 and Table2

Here are the steps you can follow：

1. Create calculated table.

Table =
SUMMARIZE(
    'Table1','Table1'[SKU],'Table1'[Sell thru Units],'Table1'[Weeks],"Sell thru",
    MAXX(
        FILTER(ALL(Table2),'Table2'[SKU]=EARLIER('Table1'[SKU])),'Table2'[Sell thru]))

2. Result:

Best Regards,

Liu Yang

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

[realme1]

Will you be able to do this in DAX because I dont have access to power quesry because source is not mine

[yakamoz007]

Hi,

you can do this in the Query Editor. Start-> Merge queries 

After that you can do some calculations on the column, because you have all the data in one table.