I am stumped trying to add a column from one table to another which have a many to many relationship.
The two tables are for a calendar visual - one table has date/time start times and the other has date/time end times for the calendar.
I tried creating an ID table with one to many relationships to both of these tables, but the calendar visual doesn't recognize the relationship between the times tables and won't work.
Ideally, I need one table with the start times end times. When I tried merge tables, it shows Table link. Is there a way to merge only the end times to the start time table in a way that is accurate by id and day name?
I've looked at relatedtable function but can't seem to get it to work the way I want.
Here is the data inside the two tables:
Start Time table:
calendar start times
End Time Table:
calendar end times
All of the columns in both tables after the start/end time are calculated columns to get the current date for the day of the week.
I tried linking the two tables on id and day name, but the calendar then shows multiple entries for every employee with every start and end time on the calendar (not correct data).
If anyone could assist with which DAX function I can use to achieve this, I'd be most grateful.