DAX

Question

Can someone please help&nbsp;I have two tables&nbsp;Table1&nbsp;col-1 col-2 col-3 col-4 col-5 col-6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cvb&nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ghTable 2col-a col-b col-c&nbsp; col-d col-eabcdf&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc&nbsp; &nbsp;ss&nbsp; &nbsp;ssf&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cvb&nbsp; gf&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;gh&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fff&nbsp;&nbsp;col c is a subset of col-4 in table 1I want to create a new tablecol-4(Table1) col-a (Table2) col-5(Table1) col-6(Table1) col-d (table2) cold-e(table2)

v-yuta-msft · Accepted Answer

Hi Surya1,&nbsp;To achieve your requirement, you can use DAX formula below:New table = SUMMARIZE(Table1, Table1[col-4], Table2[col-a], Table1[col-5], Table1[col-6], Table2[col-d], Table2[col-e])&nbsp;Regards,Jimmy Tao

Forum Discussion

DAX

2 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX