Forum Discussion
Power Query sum with exceptions
Hi, I have data in a row in this kind of format: Name1, amount, name2, amount, name3, amount, name4, amount, name5, amount Now I want to add a custom column where the output is the sum of th...
Hi Anonymous ,
I will have a static table with this information. And the total amount of columns used for this will be 9x the name (type of cost) and 9x the cost. Does this answer your question?