Forum Discussion
Calculating Average question
Community SupportHi zlottt
Could you please share the sample PBIX file or provide a small sample of the data and the current measure?
This will help clarify whether you want the average of the yearly values shown in the matrix (2023, 2024, 2025, 2026) or the average of the underlying records. It will also help determine whether the calculation should be done using DAX or Power Query.
Need help uploading data?
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/144…
Hi Thanks for the reply.
Please see a sample of the pibx
- Ashish_Mathur
Super User
Hi,
PBI file attached.
Hope this helps.
Thank you for the response.
Yes thats the results I wanted but is there a way to build these in the back end in power query? Also, make them columns not measures? Maybe with multiple queries?
- Ashish_Mathur
You are welcome. Perhaps, it can but why do you want to do this in Power Query?
