Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with the columns "ID" ,"month" , "score" and "publish date". I have a measure that gets me the "average score per publish date" and then I just filter by ID on my report page.
What I ultimately want, is to use the values in the measure "averge score per publish date" to calulcate the average score per month.
Here's a table as an example
ID | Score | Publish Date | Month |
1 | 90 | 9/14/2022 | September |
1 | 60 | 9/14/2022 | September |
1 | 75 | 9/15/2022 | September |
1 | 85 | 9/15/2022 | September |
What I want but do not know how to do.
Step 1. Averge score per publish date 9/14/2022
90+60 = 150/2= 75
Step 2. Average score per publish date 9/15/2022
85+75= 160/2 = 80
Step 3. Average score per month. ( using average score per publish date to calculate)
80+75= 155/2 = 77.5
What I know how to do but do not want.
Step 1. Average score per month( using scores to caluclate)
90+60+85+75 = 77.5
Here is also the DAX formula that I used to get the average score per publish date.
Solved! Go to Solution.
Try:
Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])
Proud to be a Super User!
Paul on Linkedin.
Try:
Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |