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.
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
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |