Power query how to sum specific rows
I will always just need to sum rows 14+15, 34+35, and 54+55. I just want m code that adds rows x+y. Why is this so difficult???
Edit: I know I can do more transformations. But am I the only one who find it ridiculous that I have to do 6 steps just to add 2 rows? Should be 1 line of code. This is why I prefer VBA lol
Edit2: This is incredibly fascinating. Given we all use excel, I hope we can all agree adding 2 rows is as basic as getting out of bed. Yet all of you are unironically telling me all these steps to take in order to accomplish such an easy task without any self awareness. I mean, if you had to take 6 steps to get out of bed, you wouldn't find that ridiculous? And everyone who says I am using the wrong tool also fails to realize the fact that such steps exist demonstrate real life requirement for it lol
[link] [comments]
Want to read more?
Check out the full article on the original site