Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Join Tables and retrieve table

Hello Folks,   AFAIK, we cannot Join tables using calculated columns. But, I am now in a tricky situation that,   I have TableA and TableB.  TableA has calculated columns( NOT custom columns.). ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
You create a new calculated table using this code

ExpectedOutput = 
SUMMARIZE (  
    CROSSJOIN ( 
        SELECTCOLUMNS ( TableB, "ID", TableB[GroupID], "Detail", TableB[GroupDetail] ), 
        TableA 
    ), 
    [PostingYear], 
    [ID],
    [Detail],
    "Spend", SUM ( TableA[ApprovedSpend] ) + 0
)