Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello 🙂
Im new at power bi, so im sorry for the noob question 😛
So i have a table more or less like this
Company | Stage |
microsoft | MAL |
asus | MQL |
toshiba | SAL |
lg | MAL |
asus | MQL |
nokia | MAL |
As you can see i have the company "asus" its duplicated, but i just want to count it once.
So i need to create a new column that verifies if the company its duplicated and if it haves the same stage and give me a result like this:
Company | Stage | Stage verified |
microsoft | MAL | MAL |
asus | MQL | MQL |
toshiba | SAL | SAL |
lg | MAL | MAL |
asus | MQL | |
nokia | MAL | MAL |
Thanks 🙂
Solved! Go to Solution.
Please refer to the steps below to achieve your requirement.
Regards,
Charlie Liao
Please refer to the steps below to achieve your requirement.
Regards,
Charlie Liao
Thats very well thought!!! Thanks a lot 😄
That is going to be challenging as presented, because there is no way to differentiate the two rows of asus,mql.
If you don't need the dupes, I would just remove them (via Edit Queries). If you do... what if you had a column that just counted the # of duplicates? That's easy... 🙂
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |