sales target by location and month

[brankojosipovic]

Hi All,

I am a beginner in PowerBI and I assume that this is fairly simple to solve.
I have three table
Products -  info about the product and storing location

ProductID	Location	ProductName
1	Warehouse1	Article1
2	Warehouse1	Article2
3	Warehouse2	Article3
4	Warehouse2	Article4
5	Warehouse3	Article5

TargetSale - which indicates how many products need to be sold in three months (June, July, August - 6,7,8)

ProductID	Month	TargetSale
1	6	50
1	7	60
1	8	70
2	6	40
2	7	50
2	8	60
3	6	30
3	7	40
3	8	50
4	6	30
4	7	40
4	8	50
5	6	70
5	7	80
5	8	90

Sales - data about how many products were sold in three months (June, July, August - 6,7,8)

ProductID	Month	Sold
1	6	10
1	7	20
1	8	20
2	6	15
2	7	15
2	8	20
3	6	20
3	7	20
3	8	30
4	6	12
4	7	12
4	8	15
5	6	15
5	7	16
5	8	18

I need to create report  with one table to look similar to this one

Month	location	Target	Sold	%(Sold/Target)
6
	Warehouse1	90	25	28%
	Warehouse2	60	32	53%
	Warehouse3	70	15	21%
7
	Warehouse1	110	35	32%
	Warehouse2	80	32	40%
	Warehouse3	80	16	20%
8
	Warehouse1	130	40	32%
	Warehouse2	100	45	40%
	Warehouse3	90	18	20%

This is relationship model

And this is my result. It is not correct as you can see

[ryan_mayu · Accepted solution]

@brankojosipovic 

try to create a dim month table.

pls see the attachment below