Forum Discussion
Average of Rates
I built out a table in powerBI to give me average of a series or rates. However, the average is wrong. I wrote out the new table like this: summarizecolumns(Sheet1[District],'Sheet1'[Fiscal Year...
Hi awashington6 ,
Please try to modify you table.
an_other =summarizecolumns('Sheet1'[Fiscal Year],Sheet1[District],"Usage Rate",Average('Sheet1'[%Beds]))
If I have misunderstood your meaning, please provide your pbix file without privacy informarion and desird output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.