March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
140 | |
121 | |
108 | |
99 | |
96 |