Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I´m trying to order a similar table in PBI, by sales desc. The thing is that I´d like to discard those companies with the same ID as it´s the case for Accesories and Accesories SL
I tried creating this column to replace Company column but it´s grouping the sales by ID and, that it´s not the expected result.
New_company=
Solved! Go to Solution.
Hi @Anonymous ,
I have assumed that you have an ID column. Please try the following :
1. Create a calculated column on your table to give you the min value of company for each ID.
2) Using ths table, create a calculated table that has company and sales
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
You have mentioned ID, where is the ID in you example?
True but it´s in the same table as the rest of the data. To make it easier just consider that if the sales quantity is the same, it´s means that they have the same ID 😅
Hey @Anonymous ,
Can you show the current result and the expected result please?
Sure, this would be:
I´d like to get for example, the min of company column in case the ID is duplicated
Hi @Anonymous ,
I have assumed that you have an ID column. Please try the following :
1. Create a calculated column on your table to give you the min value of company for each ID.
2) Using ths table, create a calculated table that has company and sales
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
74 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |