Forum Discussion
bolabuga
9 years agoHelper V
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...
bolabuga
9 years agoHelper V
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.
v-haibl-msft
9 years agoMicrosoft Employee