Date table relationship monthly

[mcornfield]

Hello, 

I have 2 tables I need to create a relationship between. 

One Has Date by the first date of the month, so monthly Data 

the other is a calendar table that is by date I have the first day of the month on there but will Many to many work?

[parry2k]

@mcornfield isn't that what you want? If your transaction table has data for a month then that is what you are getting. I'm not sure what you are trying to achieve.

Maybe it will be easier if you provide sample data with the expected output.

[parry2k]

@mcornfield you set the relationship between date and month data, which will be one to many and in every visual, it will work fine. don't set many to many relationships between the month date column from the date table.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[mcornfield]

That Limites what I get in return. 

If I use the Calendar table to look at a whole month it only returns the results for the first of the month.