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 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
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |