Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Surya1
Helper I
Helper I

DAX

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)

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

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

Capture.PNG

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

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

Capture.PNG

 

Regards,

Jimmy Tao

Hi Jimmy,

 

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

 

Please suggest.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.