Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am trying to identify if an account has specific code combination(s). I have 2 tables, one showing codes by account:
The second table showing different code combinations:
I need to see if an account has any of the code combinations and which ones, so it should look like this:
Any help would be appreciated. I am also dealing with a lot of rows (1,000,000 +). Thanks!
Solved! Go to Solution.
@PowerBI123456 - I did it this way:
Measure 5 =
VAR __Codes = SELECTCOLUMNS('Table (5)',"Code",[Code])
VAR __Table = FILTER('Table (5a)',[Code 1] IN __Codes && [Code 2] IN __Codes)
RETURN
CONCATENATEX(__Table,[Code 1] & "&" & [Code 2],", ")
PBIX is attached below sig, Page 5, Table (5) and Table (5a)
@PowerBI123456 - I did it this way:
Measure 5 =
VAR __Codes = SELECTCOLUMNS('Table (5)',"Code",[Code])
VAR __Table = FILTER('Table (5a)',[Code 1] IN __Codes && [Code 2] IN __Codes)
RETURN
CONCATENATEX(__Table,[Code 1] & "&" & [Code 2],", ")
PBIX is attached below sig, Page 5, Table (5) and Table (5a)
@PowerBI123456 , Can you explain the logic behind it.
@amitchandak hi - what do you mean? That last table is what I am trying to get to in Power BI. I am just trying to see at the account level, if has any of the code combinations from the second table and which ones. Thanks!
Hi @PowerBI123456 ,
Have you resolved it? If yes, please accept the helpful answer as solution. Others will benefit from this thread. Thanks! If you still need help, please feel free to ask us.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |