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
I'm giving this another go because the solution provided wasn't really clear and didn't articulate for me customizable fields (Caution: I am green in this space so I would need step-by-step or a screen image of the DAX function you write so i can try to mimic using my real data)
I have a basic dataset like this
CustomerID | ProductID |
11111 | A |
22222 | C |
33333 | A |
22222 | C |
44444 | A |
66666 | A |
55555 | B |
What I'm trying to do is to add a column that will flag other purchases that this same customer made elsewhere in the table, so I want my final dataset to look like this
CustomerID | ProductID | ProductAFlag | ProductBFlag | ProductCFlag |
11111 | A | Y | N | N |
22222 | C | Y | N | Y |
33333 | A | Y | N | N |
22222 | A | Y | N | Y |
44444 | A | Y | Y | N |
66666 | A | Y | N | N |
44444 | B | Y | Y | N |
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
All DAX forluma for creating calculated columns are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
All DAX forluma for creating calculated columns are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
119 | |
106 | |
78 | |
73 | |
52 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |