Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Kindly assist, I'm still new to Power BI. I'm trying to read the targets from Target's table to the 2020 sales but I'm not getting the desired/unique results.
The targets are per Month, per Category, per Region, per Channel and I'm struggling to get unique values for this.
I have tried linking the 2020 table with Targets table using the "MONTH" field but the results are the same,
what is the relationship between? you need to create the relationship on channel between 2020 and targets, the date table should be linked separately to the target, not through 2020, and it would be better to have a lookup table called channel and then you link both the target and 2020 to that table.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |