Table Merge

[mccollough]

Hello!

I have a fact table and value table that I'm having trouble merging

Fact Table

Rep	Service Line	Date
Mike Sanchez	2760	7/13/21
Henry Honcho	3490	7/12/21
Billy Skywalker	2420	7/12/21

Value Table

Service Line	Value Units
2760	50
3490	20
2420	10
1738	100

My goal is to be able to visualize the value derived from each rep over a given period of time.

I tried to add a value column to my fact table, but the merge function wouldn't recognize 'Value Table'[Service Line] & 'Fact Table' [Service Line].

Is there another way to do this I could try? 

Are there any other ways to achieve my goal without combining the two tables?

Thanks everyone! Your help is tremendously appreciated!!

[Ashish_Mathur]

Hi,

What end result are you expecting?

[aj1973 · Accepted solution]

Hi @mccollough 

Your Model should look like this

Add Column to have this