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.
I was wondering whether it's possible to ask power bi an average question. This question works:
"all student patient adult greater than 4" (shows all the students who have more than 4 adult patients)
but the average doesn't seem to be possible:
"all student less than patient adult average"
to get the list of students who have less than the average number of adult patients. There isn't an average column, just students and total of various types of patient.
thanks,
Alistair
Solved! Go to Solution.
Hi @codebrane ,
Based on my test using Power bi desktop version : Version: 2.79.5768.721 64-bit (March 2020). I can get the average by Q&A.
Could you please share your sample data to me to have a test if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.
Hi @codebrane ,
Based on my test using Power bi desktop version : Version: 2.79.5768.721 64-bit (March 2020). I can get the average by Q&A.
Could you please share your sample data to me to have a test if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.
sorry I can't share the data but thanks for the pointer. I can use it to get to the answer.
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.