Forum Discussion
SBGoh
Helper I
Helper ICompare 2 calculated field from different table
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 |
see attached
