Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
Solved

Add additional column for source in a calculated column

Hi,

I created the following calculated column but I would like to add another column that can show me the source/table where comes each row: Example > Sales, MMS, NCC, PLAN, REVENUE - CCI :

CALCULATEDTABLE =
VAR V1 = SUMMARIZECOLUMNS(Sales[Client Group])
VAR V2 = SUMMARIZECOLUMNS('MMS CFY'[CG])
VAR V3 = SUMMARIZECOLUMNS(NCC[Client Group Categorization])
VAR V4 = SUMMARIZECOLUMNS(Plan[Client Group])
VAR V5 = SUMMARIZECOLUMNS('Revenue - CCI'[Client Group])
RETURN
UNION(V1,V2,V3,V4)
 
 
Any idea ? 
 
Thanks 
 
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    cristianml , try like

     

    CALCULATEDTABLE =
    VAR V1 = SUMMARIZE(Sales,Sales[Client Group], "Table", "Sales")
    VAR V2 = SUMMARIZE('MMS CFY', 'MMS CFY'[CG], "Table", "MMS CFY")
    VAR V3 = SUMMARIZE(NCC,NCC[Client Group Categorization], "Table", "NCC")
    VAR V4 = SUMMARIZE(Plan,Plan[Client Group], "Table", "Plan")
    VAR V5 = SUMMARIZE('Revenue - CCI','Revenue - CCI'[Client Group], "Table", "Revenue - CCI")
    RETURN
    UNION(V1,V2,V3,V4)

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    cristianml , try like

     

    CALCULATEDTABLE =
    VAR V1 = SUMMARIZE(Sales,Sales[Client Group], "Table", "Sales")
    VAR V2 = SUMMARIZE('MMS CFY', 'MMS CFY'[CG], "Table", "MMS CFY")
    VAR V3 = SUMMARIZE(NCC,NCC[Client Group Categorization], "Table", "NCC")
    VAR V4 = SUMMARIZE(Plan,Plan[Client Group], "Table", "Plan")
    VAR V5 = SUMMARIZE('Revenue - CCI','Revenue - CCI'[Client Group], "Table", "Revenue - CCI")
    RETURN
    UNION(V1,V2,V3,V4)