How to construnct relationship between tables in the most correct way?

[darkmetrics]

Good afternoon!

I have 3 tables in my Power BI report:

daily sales table (something like this)

monthly sales plan table

and dimDates table 

I want to make a chart like this:

I think I will aggregate daily fact sales into monthly fact sales with a simple measure. But what is the best way to build relationships between the tables above to construnct the chart I want?

[davehus]

Hi @darkmetrics ,

In powerquery, if you a create a column with Date.EndofMonth on date to get the end of month. Then use group by to summarize the data using the end of month column , fact_sales. Join both the daily sales and sales plan to the date table and you should get the desired outcome.

Hope this helps.

Did I help you today? Please accept my solution and hit the Kudos button.