Active Member
May 2, 2022
Hello everyone, i think i have a simple problem but i don't know how to do this. For example, i want to add a column Model_Without_duplicates and Section_Sum like in the image below. How can i do this in power query?
Model | Section | Model_Without_duplicates | Section_Sum |
M100 | 25 | M100 | 80 |
M100 | 25 | M101 | 65 |
M100 | 30 | M102 | 100 |
M101 | 30 | ||
M101 | 35 | ||
M102 | 50 | ||
M102 | 50 |
Moderators
January 31, 2022
Active Member
May 2, 2022
I understand what you did in excel. But i'm trying to do this in power query in power bi to automate this process in a table with 20000+ parameters. I've read this topic: https://www.myonlinetraininghu.....sum-column and my doubt is about to integrate my ideia to this code or something simmilar.
Do you think im in a wrong way to do this? If yes, could you suggest another topic to read?
I'm not a expert in power bi, but i'm trying to learn.
Best regards.
1 Guest(s)