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,
I am a beginner and I tried to create a pivot table to show sales name and their respective pipeline ( oppty table) and attainment ( attainment table)
I create a new table to group the sales name and their pipeline - it works.
However when I tried to add the field with attainment data together - the value is off. All the sales have same pipeline number.
Can anyone advice me what should I do? Here is the relationship I created
Solved! Go to Solution.
The first one is coming from M1. M1 is not joined with other tables. So when you try yo pull in data for other it is showing wrong values.
Please check how these can be joined.
The first one is coming from M1. M1 is not joined with other tables. So when you try yo pull in data for other it is showing wrong values.
Please check how these can be joined.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |