Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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... 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |