cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Join two tables with different number of rows and columns to one bar graph

I have two tables. One is "Sales" the other is sales "Goal". So sales have the "sale ID" which I want to count to show a monthly count of sales bar chart with a line showing the goal for that month. I also need to drill down to the month and show the sales per day in the month along with the line representing the goal divided by the days of that month. My problem is the data does not have the same columns. How would I fix this? Please and thank you.

GoalGoal

 

SalesSales

 

2 REPLIES 2
Anonymous
Not applicable

Hi @Jbmolina93,

 

We need to first create common columns in the 2 tables to join them.

 

For Table 1 Create a Month_Year column:

 

Month_Year = 'Goal'[Date] & ", " & 'Goal'[Year]

 

For table 2:

 

Month_Year = FORMAT('Sales'[Date], "MMM, YYYY")

 

Then join these columns and you should be good to go.

I get an error when I try and join.

"The column with the name of 'Date' already exists in the 'Table' Table."

error.PNG

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors