Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Full outer join using calculated columns

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.). ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could get the result by creating a measure.

    Measure = 
var _value = CALCULATE(SUM(TableA[ApprovedSpend]),FILTER(ALLSELECTED(TableA),TableA[PostingYear]=SELECTEDVALUE(TableA[PostingYear])&&TableA[GroupID]=SELECTEDVALUE(TableB[GroupID])))
return
_value+0

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You could get the result by creating a measure.

Measure = 
var _value = CALCULATE(SUM(TableA[ApprovedSpend]),FILTER(ALLSELECTED(TableA),TableA[PostingYear]=SELECTEDVALUE(TableA[PostingYear])&&TableA[GroupID]=SELECTEDVALUE(TableB[GroupID])))
return
_value+0

 

Best Regards,

Jay