Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Ive been trying to search the community for answers but havent found the rigth solution yet.
I have two tables and in both tables the i have a column with order numbers, i have a realtionship many to many.
In one of the table there is a field called "created by" (which tells what person have created the order). I want to add that column to the other table every time the order numbers match. So if a order number have a created by it writes the created by person in everytime the number accurs. (So i kinder want a match formel for it)
Its automatic O-DATA i use, if that is relevant.
Hope it makes sense and there is a solution.
Solved! Go to Solution.
I found the solution. i used this formel
Created by= Calculate(Firstnonblank('table A' [Created by],1),FILTER(ALL('Table A'),'Table A' order number='Table B' Order number))
I found the solution. i used this formel
Created by= Calculate(Firstnonblank('table A' [Created by],1),FILTER(ALL('Table A'),'Table A' order number='Table B' Order number))
@Wengel
Add the following Column in Table A
User ID - B - LOOKUPVALUE ( Table B[Created BY] , Table B[ User ID] , Table A[ User ID] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Didn't know the lookup could work, but i get an error "A table of multiple values was suplplied where a single values was expected), I have removed duplicates from table B so there should only be one of each order number, but in table A there are more then one of each number, since it tells what cost account they go in to.