Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good morning,
I want to be able to create a conditional column knowing that my main column can have multiple values for the same ID.
Here is an example of what I want to do.
Entreprise | Value | RESULTS -> | Entreprise | Value | ||
A | 1 | A | 2 | |||
A | 3 | B | 0 | |||
B | 1 | C | 1 and 3 | |||
B | 2 | |||||
B | 3 | |||||
C | 2 |
How can I do this please?
Solved! Go to Solution.
I have resolve my problem using CONTAINS function and a conditionnal column.
Thanks
I have resolve my problem using CONTAINS function and a conditionnal column.
Thanks
Hi @AlexisPREVOT - can you please help on the result values.
A
B
C
is coming as a group but the values , how it is coming 2 , 0, 1 and 3
share with some sample data.
you can do group by in power query editor on the enterprise column.
Conditional statement:
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Good morning @rajendraongole1 ,
You should see the results 0 1 2 3 as categories of invoiced items.
If I sell 1 and 2 then I can sell 3 to my customer.
Same, if I sell 1 and 3 then I can sell 2.
I just tried your solution but I don't see how I could make my groupings, it seems too complex to me
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |