Is there a way to relate a Calendar lookup table and a 24hr Time lookup table to 2 different tables on more than 1 column in PowerBI?
I have 2 tables, encounters table and procedures table, that both have 2 columns containing a date data type and 2 columns containing a time data type. I have created a Calendar lookup and a Time lookup table to connect with the aforementioned tables to create a relationship in my data model and build a heatmap with each “60 Min Slot” as columns. I can’t figure out a way to get around the many-to-many relationship that happens when I try it the way I thought would work. Data imported from csv files.