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
Anonymous
Not applicable

Combine - Two Calcualate tables into one Table

Hi Experts

 

how could i modify the following DAX to combine the two seperate Calculated Tables into one master table

 

Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI")

 

Sub 2 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="DPI")

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI || Device_Type[Type]="DPI)

View solution in original post

5 REPLIES 5
PaulDBrown
Community Champion
Community Champion

Is there a reason you need actual physical tables?

can you provide sample data or PBIX file and explain what you need to compute?

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Would the following work: 
Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI && Device_Type[Type]="DPI)

Anonymous
Not applicable

Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI || Device_Type[Type]="DPI)

You can try:

New Table = 

VAR Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI")

 

VAR Sub 2 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="DPI")

RETURN
UNION(Sub 1, Sub 2)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Hi Paul - currently the two calculatetables are giving me two seperate table one showing MDI info and the other showinf DPI info....the columns in both table are the same less the device type. i just want one table to show both MDI & DPI in one calculated table...

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.