Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add dimension within addcolumn union

Hello!   I made 2 manual dimension tables, named 'Company' and 'Teams'. Also made a calculated table as shown below. With this table I'm able to merge 'Sales' and 'Costs' within the same table.  ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    You could use this formula as below:

    Table = 
UNION(
    ADDCOLUMNS(
        'Company',
        "Team", "",
        "Type", "Sales",
        "TestMeasure", TODAY()
    ),
        ADDCOLUMNS(
        GENERATE('Company',FILTER(Team,Team[Team]<>3)),
        "Type", "Costs",
        
        "TestMeasure", NOW()
))

     

    Result:

     

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , It should work by giving column name like

 

Facts = 
UNION(
    selectCOLUMNS(Table1,"Company";
        Table[Company];
        "Type"; "Sales";
        "Team"; "";
        "TestMeasure"; ... 
    );
        selectCOLUMNS(Table1,"Company";
        Table[Company];
        "Type"; "Costs";
        "Team"; Table[Team];
        "TestMeasure"; ...
))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak thanks for your reply!

 

Maybe im missing something, but addcolumns expects an expression. Table[team] is not an expression.

I tried a lot of different expressions, but I'm not able to find the correct one.

 

The best one I found was RELATED('Team'[Team]). Unfortunatly this gave the result below.

CompanyTypeTeam
ASales 
BSales 
ACosts1
BCosts2