Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Is there a reason you need actual physical tables?

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

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...