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 Folks
I have the following data:
I am trying to calculate the average pages per day - i.e. average pages on a Thursday = xxxx
Have tried a few formulae but can't seem to hit the right one - any ideas?
Thanks
I'm looking for something similar but average per month
Hi @bryan_d,
if you only want the average for one day the solution provided by @MattAllington is the best.
While if you are searching for the average for every day you can try this:
1) you can visualize the day column like a table (and sort it by the "DayOfWeek(no)" column)
2) after that you can create a measure with this formula: averagePages = AVERAGE(yourTable[Pages])
3) and you obtain this:
Let me know if it works (and if it's what you were searching for).
#I'M Not An Expert#
i tried something similar by day of week but it return the average if everything not that day of week =( help? please?
Try this
Average for Thursday = calculate(Average(TableName[Pages]),TableName[Day]="Thu")
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |