Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm trying to replicate the following, where I had been using the index/match/contif combo in Excel.
Table: Labor (For each employee added to a receipt in our system, a seperate row)
| Receipt | Associate | Name |
| 125861 | 1276 | Employee 1 |
| 125861 | 1391 | Employee 2 |
| 125861 | 1501 | Employee 3 |
I need to display this data in a Power BI table, in the following format:
1. No duplicate receipt ids (I have them coming from a related table without dups so no big)
2. Return the Name(s) for the given Receipt id, accross the 4 columns.
| Receipt | Assoc. #1 | Assoc. #2 | Assoc. #3 | Assoc. #4 |
| 125861 | Employee 1 | Employee 2 | Employee 3 |
Here is the Excel Formula that would be in B2 and copied right.
INDEX(Labor!$C:$C,MATCH(0,IF($A1=Labor!$A:$A,COUNTIF($A2:A2,Labor!$C:$C),""),0))
Possible? Need more info?
Thanks in advance.
If anyone has any resources on this, it would be greatly appreciated. Thanks
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |