Forum Discussion

Wresen's avatar
Wresen
Post Patron
6 years ago
Solved

Calculation between 2 tables

Hi , and thanks for reading this.   I am still learing this but and i have hit a litte bump on the road.   I have 2 tables   I have a relationship between Month and Month (one to one,...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Wresen 

     

    try this

    Measure 2 = calculate(sumx(test;calculate(sum(test2[Matte]))*calculate(sum(test[value]))))
az38's avatar
az38
Community Champion
6 years ago

Wresen 

well, if try to descripe it simple:

sum - is a sum of values from one exactly column (maybe with some filters)

sumX - is a sum of a calculated expressions which could use more than one column

Wresen's avatar
Wresen
Post Patron
6 years ago

Sorry for late answer.

Thanks so much for the help

 

I have one more strange question regarding this.

How do i use a IF statment in this example.

 

The table "test2" does not excist and and want to:

If test.month =1 then value *2 ; If test.month =2then value *3;If test.month =3 then value *4

 

I also want the claculation to be correct when i remove month.

I hop i have manages to explain myslef.

 

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Wresen 

    create new calculated column in the table 1 with IF statement then multiply as you wish

    ...if i understand you correct :)

    • Wresen's avatar
      Wresen
      Post Patron
      6 years ago

      Hi Az38 ;and Thanks for helping

       

      It needs to be a mesure since the multiplyed value will change depening on filters (if i managed to make the report)

       

       

      We have this table , and i want to make a measure that checks the month and depeding on month it will multiply with a number.

      If (month = 1 then value *2;If (month = 2 then value *3;If (month = 2 then value *4;

       

      and when i remove month  and value i want the still be there

       

      So if it would work i would have Measure to the right of year and a value 35