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 , can you share source data. You have already shared desired output