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!!
