Forum Discussion
DAX Function Sort by Duplicate
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.
Hey, already night my time zone, 21:35 so ping me here tomorrow and we'll do a zoom
5 Replies
Anonymous check out the file sample solution.
Let me know if this is what you meant.
DAX Function Sort by Duplicate 2022-08-04.pbixHello 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?