Forum Discussion

bolabuga's avatar
bolabuga
Helper V
9 years ago

query editor calculation.

  Hello, i would like some help, im trying to do the following on the query editor.   as shown on the screenshot for the columns, i need to do:   [sum of consumes] divided [sum of homes] f...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

I would suggest then that you keep things simple and do it step by step rather than in one task.

 

Make a calculated column:    sumC = Sumx(Table,Field)

Make a calculate column:      sumH = Sumx(Table,Field)

 

this allows you to visually verify

 

then make a calculated column: Final = IF([type] = "R" AND [identification] = "condominios"),sumC/sumH,0)

 

 

bolabuga's avatar
bolabuga
Helper V
9 years ago

Interesting approach, i will test to see how things look like with this. I actually did all in one go with "calculate", "divide" and "filter", but the way you suggested is simpler.

 

Any way, thks both cahaba and bavesh, to learn how to use chains of DAX commands in powerquery i will probably need to do a online course or something that is more time consuming. I just read "Power Query Formula Language Specification (August 2015)", but its all CLOUDY right now hauahuah.

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    actually my suggestion renders a different value per row - - and am not sure that is what you seek based upon our original exchange. 

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    bolabuga

     

    Have you got this problem solved with CahabaData’s solution?

     

    Best Regards,

    Herbert