Hello,

It's me again...

I'm starting to connect my various spread sheets and tables together in Power BI, and have come across a new issue.

My main data set is a big source of energy consumption on 15 minute and hourly granularity. This works great to visualize in various graphs. I have successfully been able to combine it with hourly data for temperatures for example. I can view the data on hourly level, but also on daily, monthly and quarterly level by using the date hierarchy.

I have some data sets (visitors for example) that is only reported only on monthly level. I'd like to view the energy consumption on monthly basis and see the visitor data in the same visualization.

My take on this is that I should connect the YYYY-MM from the visitor table with the YYYY-MM from my date table. But since my date table in on 15 minute and I have many stores with visitor data, that gives me many to many relationships. From what I can see it works, but I get a warning and in the tutorial for that part there are many warnings.

Is there any better way to do this? Should I make some sort of extra table? Or is this one of the cases where it might actually be okay with a many-many relationsship?

Many thanks!