The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
why is it using max or min? not kinda sure on how do you do it when u group by the other two columns.
Hi @Anonymous
If you want to get unique values from "BR" and "Chassis" you will have to do something about the rest of the columns.
when you use remove duplicates it will use do a similar thing ( take the unique values of selected columns and take first value of every other column not included in the selection )
What would be the desired outcome that you are expecting?
Hi the outcome is actually that. it's just the when i remove both br and chassis it doesnt match my excel total number of rows.
in excel when i remove both its "8737" but in power bi is 8725 im guessing its because it only remove the chassis duplicates 😞
it is possible to give me a step on how you do your solution? thanks
Hi @Anonymous
Could you please kindly share your sample pbix that we can draw it up for you?
Make sure you've shield the confidential info before sharing.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
93 | |
78 | |
62 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |