Date table relationship monthly

mcornfield · ‎02-04-2022

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 · ‎02-04-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎02-04-2022

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

mcornfield · ‎02-04-2022

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.