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.
Hello,
I'm trying to create a measure to check the occurrence of an ID in two different categories and then classify it as a third category.
Ex:
[ID] [BASE]
123145 Table
54845 Homebroker
8485 Homebroker
123145 Homebroker
54845 Table
Result
[ID] [BASE] [CLASS]
123145 table MHB
54845 table MHB
Could anyone help me?
In short, there are two columns, and every time an ID occurs in MESA and HOMEBROKER it becomes an MHB(Mesa-Homebroker). I would like to create another column with the name MHB and the other empty values.
Solved! Go to Solution.
Hey, already night my time zone, 21:35 so ping me here tomorrow and we'll do a zoom
@Anonymous check out the file sample solution.
Let me know if this is what you meant.
DAX Function Sort by Duplicate 2022-08-04.pbix
Hello SpartaBi,
Thanks for helping me.
But in this case, it's just checking if the ID is table, correct?
He needs to check if the ID has like two categories HOMEBROKER and TABLE, understand?
Same ID, can have two categories in the same column.
That is, the same ID will happen more than once in the same column, one of them being MESA and another HOMEBROKER, if so, it will be classified with MHB.
I even tried to change it here, but I get an error in the number of columns.
@Anonymous do you want to show me on zoom/teams?
Yes, I would like a call via Zoom.
Would be great. Can we do it at 4:30 pm?
Hey, already night my time zone, 21:35 so ping me here tomorrow and we'll do a zoom
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |