Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
try to create a dim month table.
pls see the attachment below
Proud to be a Super User!
try to create a dim month table.
pls see the attachment below
Proud to be a Super User!
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |