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
I am having below data
I want to calculate the average cumulative value . Need output as below. I did this calculation in Excel and sample excel file attached here https://we.tl/t-Y8TKJrgVYB
Average Cumulative of 484.50 for 30th Sep is average of all the values. For 29 sep, average cumulative is 482.86 is average of values from 23 sep to 28 sep. Same is applicable for other dates.
Can anyone advise me how to do this in Power BI?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @bourne2000
Try this:
Average cumulative =
CALCULATE (
AVERAGE ( table[Value] ),
FILTER ( ALL ( table ), table[Date] <= MAX ( table[Date] ) )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@VahidDM Thanks for your reply. Values are not coming correct. My value column in the table is measure. Is this something an issue?
Can you share the DAX code of the Value measure with a sample of your data?
Thank you
I am having below table
Here the average column is a measure. Below caulcuation I did
I want to calculate the average cumulative value . Need output as below. I did this calculation in Excel and sample excel file attached here https://we.tl/t-N2e7mLeMaF
Cumulative Average is 1045.428571 for 30th Sep is average of all the values. For 29 sep, cumulative average is 1046.83333 is average of values from 29 sep to 30 sep. Same is applicable for other dates.
PBIX file attached here https://we.tl/t-0g7kEMYd7O
Hi,
You may download my PBI file from here.
Hope this helps.
Hello!
Way you can share the file with me? I have a similar problem and would like to open the code that was used 🙂
Hi,
I do not have that file now. Share some data to work with, explain the question and show the expected result.
You are welcome.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |