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.
Hello!
Hoping the big brains on here can help me 🙂
Here is an example of my data:
ProductID | Facility | Sku | SkuFacility | MadeInFacility | TransferFrom | SkuTransferFrom |
6 | A | 1234 | 1234A | Y | ||
7 | B | 1234 | 1234B | N | A | 1234A |
8 | C | 1234 | 1234C | N | A | 1234A |
9 | D | 1234 | 1234D | Y |
I want to get a final column that looks like this:
ProductID | Facility | Sku | SkuFacility | MadeInFacility | TransferFrom | SkuTransferFrom | TransferTo |
6 | A | 1234 | 1234A | Y | BC | ||
7 | B | 1234 | 1234B | N | A | 1234A | |
8 | C | 1234 | 1234C | N | A | 1234A | |
9 | D | 1234 | 1234D | Y |
I tried using this expression:
Solved! Go to Solution.
Are you sure? did you create a new column or new measure? this returns BC when used as a measure for me.
Anyway, for a column try this:
TransferTo1 = calculate( CONCATENATEX( VALUES('Table'[Facility]); 'Table'[Facility]; "" ); filter( all('Table'); 'Table'[TransferFrom]=EARLIEST('Table'[Facility]) ) )
@Anonymous Are you saying that there are instances where there should be more than one id in the TransferTo field?
@jtownsend21 Yes, as in the example above the item transfers to two facilities (B and C) from A.
@Anonymous
Can you use a measure or must it be a column?
Here is a measure:
TransferTo = calculate( CONCATENATEX( VALUES('Table'[Facility]); 'Table'[Facility]; "" ); filter( all('Table'); 'Table'[TransferFrom]=SELECTEDVALUE('Table'[Facility]) ) )
you can probably make something similar as a column if needed 🙂
@Anonymous Thank you for your help! Unfortunately I am getting the result of ABCD instead of just BC for this particular SKU. Any ideas? Thanks again!
Are you sure? did you create a new column or new measure? this returns BC when used as a measure for me.
Anyway, for a column try this:
TransferTo1 = calculate( CONCATENATEX( VALUES('Table'[Facility]); 'Table'[Facility]; "" ); filter( all('Table'); 'Table'[TransferFrom]=EARLIEST('Table'[Facility]) ) )
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |