Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I'm trying to create a measure where I can get the average week total amount just for "ART-RT",my data looks like this:
To get this measure in Excel it was the ART-RT Total Amount / 4 (since the first working week started on the 3rd)
How would I create this into a measure using "specific dates"(Jan.2-Jan.6), and with FILTERS to show the average just for ART-RT?
Thanks for any help.
Solved! Go to Solution.
I'm not sure if this is what you want. (It seems too simple.)
I made up some sample data and came up with a simple model.
If this isn't what you want, I'll need some details on how you want to use it.
(Also, a weekly average is an average of the whole week - NOT an average of the daily averages.)
https://1drv.ms/u/s!AnF6rI36HAVkhPIeEthiRMCIS7mi5Q?e=1ZVmS6
One of the measures the I've built is a Sale Week total:
my measure looks like this
with that measure I've created cards for each week:
I would like to mirror these with a "AVERAGE" measure under all the Sales Weeks but when I replaced SUM with AVERAGE, it did not give me the correct value I need it.
Could you please show an example of the dataset?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
sure this how my data looks:
Yes, that is correct
I'm not sure if this is what you want. (It seems too simple.)
I made up some sample data and came up with a simple model.
If this isn't what you want, I'll need some details on how you want to use it.
(Also, a weekly average is an average of the whole week - NOT an average of the daily averages.)
https://1drv.ms/u/s!AnF6rI36HAVkhPIeEthiRMCIS7mi5Q?e=1ZVmS6
This does help alot!, thank you
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |