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

View all the Fabric Data Days sessions on demand. View schedule

Reply
stribor45
Post Prodigy
Post Prodigy

Virtual Table by UNION of two other tables

I am trying to create a virtual table but I think I am having syntax issues. can someone correct this into a working DAX code please

 

T1 = ALL(tableA[col1],tableA[col2]),

T2 = ALL(tableB[col1],tableB[col2]),

 

return UNION(T1,T2)

1 ACCEPTED SOLUTION
stribor45
Post Prodigy
Post Prodigy

That did not work for me but this did

 

 

 

My Table = 

VAR T1 = SUMMARIZE('TableA','TableA'[Call_ID])
VAR T2 = SUMMARIZE('TableB','TableB'[Call_ID])
RETURN UNION(T1,T2)

 

View solution in original post

2 REPLIES 2
stribor45
Post Prodigy
Post Prodigy

That did not work for me but this did

 

 

 

My Table = 

VAR T1 = SUMMARIZE('TableA','TableA'[Call_ID])
VAR T2 = SUMMARIZE('TableB','TableB'[Call_ID])
RETURN UNION(T1,T2)

 

jdbuchanan71
Super User
Super User

ALL(tableA[col1],tableA[col2])
UNION
ALL(tableB[col1],tableB[col2])

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors