Forum Discussion
query editor calculation.
Thks Bhavesh, but i dont think i can use that example.
Because the columns that i need to divide have lots of differents values, or at least im not seeing how this would apply to my case where i want 1 value across all rows in a new column, and this value is the result of the formula above.
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)
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.
actually my suggestion renders a different value per row - - and am not sure that is what you seek based upon our original exchange.
