DAX

[Surya1]

Can someone please help

I have two tables

Table1

col-1 col-2 col-3 col-4 col-5 col-6
                             abc              b
                             cvb     a
                             gh

Table 2

col-a col-b col-c  col-d col-e
abcdf           abc   ss
   ssf             cvb
  gf               gh              fff

col c is a subset of col-4 in table 1
I want to create a new table

col-4(Table1) col-a (Table2) col-5(Table1) col-6(Table1) col-d (table2) cold-e(table2)

[v-yuta-msft · Accepted solution]

Hi Surya1,

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])

Regards,

Jimmy Tao

[Harinath]

Hi Jimmy,

when i am trying above DAX Formula, I am unable to select second table column name.

Please suggest.