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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot!

    The application of the generate function is what I was looking for. 

    You even filtered out team 3 from my example to get the desired result 😉