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

 

DescriptionAmount 
BUCKET 1$575.00 
BUCKET 2$285.00 
BUCKET 3$135.00 
BUCKET 4$155.00BUCKET 1 -(BUCKET 2 + Bucket 3)
BUCKET 5$125.00 

 

Query 2: output 

 

DescriptionAmount 
BUCKET 6$100.00 
BUCKET 7$70.00 
BUCKET 8$25.00 
BUCKET 9$5.00(BUCKET 6 - (Bucket 7 + Bucket 8))
BUCKET 10$45.00 

 

Query 3: Output 

 

DescriptionAmount 
Bucket 11100 
Bucket 1245 
Bucket 1325 
Bucket 1430(Bucket 11 - ( Bucket 12+Bucket 13))

 

 

Problem / Help required

 

I have to create a New Calculation which has to be calculated like below

 

Bucket 15 = BUCKET 4 + Bucket 9 + Bucket 14

 

Can someone please help me with this, as I don't know how to create a calculation on top a row inside the table.

 

Thanks in advance 

 

 

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.

     

     

2 Replies

  • 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.