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.
Hello,
I have a data model containing one fact table and two dimension tables.
What I want to calculate is the following table:
So profit can just be a SUM(Profit), but the column weight needs to be a measure. It needs to be the weighted average over the selected days. But as you can see. The Fact table doesn't need to contain data for every day. So the measure needs to keep that in mind.
So the question is, How can I calculate the weighted average per team/teams per selected amount of days?
Thanks in advance!
Solved! Go to Solution.
https://www.dropbox.com/s/w435mnlx2tnwc6f/rocco.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
https://www.dropbox.com/s/w435mnlx2tnwc6f/rocco.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
32 | |
30 | |
18 | |
18 |