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.
Hi,
I have the following data model, I need to reject data from the [action] column, one [id_kth] can have several [actions. How can I delete selected records [share]?
Hi @marioxp,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @marioxp
I'm sorry! your question is not very clear to me; can you explain it with an example please?
hi @dilumd
Below is an example of a client who participated in Action 3 but did not participate in Action 2 - I have to reject them. According to the attached data, I should only be the first customer.
I want to show to clients who should take part in action 2, that is still not participating in them.
I think I explained the situation.
Hi @marioxp
According to the way I understood, if you don’t have “Action 2” inside your column you need to reject them.
Use below.
Action 2 = IFERROR(IF(SEARCH("Action 2",Actions[Action],1,BLANK()),"Pass","Reject"),"")
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 |
---|---|
114 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |