How to get product names based on IDs across two tables which have one to many relationship

[PbiCeo]

Hello everyone,

I want to get product names related to the same IDs between tables createing a measure or calculated column on the TableA and display them on a slicer.

TableA:

Date	IDa	ProductName
2021/6/1	1	book
2021/6/2	2	note
2021/6/3	3	pen

TableB:

Date	IDb	KW
2021/6/4	4	123565
2021/6/5	2	467234
2021/6/6	5	3423

The relationship between the tables is IDa (many) to IDb (one).
I try a measure and calculated column to do this, but I can't get correct values due to error.
Any idea, please?

Thanks,

Vladi

[Fowmy · Accepted solution]

@PbiCeo 

You can add a Calculated Column in Table B with the following formula:

Name = RELATED( TableA[Product name] )