Compare 2 calculated field from different table

[SBGoh]

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

[lbendlin · Accepted solution]

see attached

[SBGoh]

Hi @lbendlin , Thank you. You solved my problem.