Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a Calculated Column from Different Tables/ queries based on calculation columns

Hi All,   need some help in creating the calculation     I have 3 queries     below listed is actual data output from the Queries    Query 1   Description Amount   BUCKET 1 $575.00...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can create measure like DAX below.

     

    Sum=

    var d4 = CALCULATE(MAX(Query 1[Amount]),FILTER(Query 1,Query 1[Description]="BUCKET 4"))

    var d9 = CALCULATE(MAX(Query 2[Amount]),FILTER(Query 2,Query 2[Description]="BUCKET 9"))

    var d14 = CALCULATE(MAX(Query 3[Amount]),FILTER(Query 3,Query 3[Description]="BUCKET 14"))

    return d4 +d9 +d14

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

You can create measure like DAX below.

 

Sum=

var d4 = CALCULATE(MAX(Query 1[Amount]),FILTER(Query 1,Query 1[Description]="BUCKET 4"))

var d9 = CALCULATE(MAX(Query 2[Amount]),FILTER(Query 2,Query 2[Description]="BUCKET 9"))

var d14 = CALCULATE(MAX(Query 3[Amount]),FILTER(Query 3,Query 3[Description]="BUCKET 14"))

return d4 +d9 +d14

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-xicai  thanks it worked :)