The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have the following Sales Order table and I want to find the respective CS name from Employee table. However the CS No. in Employee table is prefix with '0's. Is there are way to use DAX to link the 2 table to get the CS name ?
Sales Order | |||
SO # | POS # | Material | CS No. |
1900 | 0011 | PartNum 1 | 100001 |
1900 | 0022 | PartNum 2 | P20000 |
Employee | |
CS No. | Name |
0000100001 | Nick Chan |
0000P20000 | Tony Liu |
Solved! Go to Solution.
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
15 | |
12 | |
12 | |
7 |