Forum Discussion
Create report from from two tables
I want to create a report that will show gross sales (budget) vs. actual sales. For some reason, the report generated repeats actual sales data every month. Here's my dummy sample report. I'm also new to Power BI.
Ice1341 Seems like there is no relationshipt built between the two tables.
And looking at the samlple data, Cust Code from Sales Budget should be joined with JF Code in Sales Invoice data which should resolve the issue.
7 Replies
Ice1341 Seems like there is no relationshipt built between the two tables.
And looking at the samlple data, Cust Code from Sales Budget should be joined with JF Code in Sales Invoice data which should resolve the issue.
Yes, I created a relationship based on the customer code, but I want to view data by month. If I use the date in the sales budget table - gross sales appear correctly by month, but sales orders repeats every month. How can I combine dates from each table to use in the report? See screenshot, Gross Sales Correct, but actual sales repeat every month when it should just appear for Jan Sales.
I can only create a relationship with sales budget dates, I get the error: the sales order table can't create a direct active relationship...I have to deactivate the relationship between the sales budget and the date table.
I found a workaround that filtered dates into my report correctly. Thanks everyone for your help!
