Forum Discussion
How do I calculate Average Daily Census on this data?
Luckily, you don't need any prgramming knowledge to get this. If you right click the table Globa28DailyCensusMA, and select the New Quick Measure option, you'll launch a helpful wizard. You want an average by category, with that category being the date. The base value would be a count of any column from the table.
That will create the measure for you! Mine looked like this:
Average Daily Census = AVERAGEX( KEEPFILTERS(VALUES('Table'[visit_start_date])), CALCULATE(COUNTA('Table'[Visit Type])) )I put that in some table visuals, filtering them by the age of the person, and came up with this from your example data. Try it with your data, and see if you come up with what you're looking for!
Luckily, you don't need any prgramming knowledge to get this. If you right click the table Globa28DailyCensusMA, and select the New Quick Measure option, you'll launch a helpful wizard. You want an average by category, with that category being the date. The base value would be a count of any column from the table.
That will create the measure for you! Mine looked like this:
Average Daily Census =
AVERAGEX(
KEEPFILTERS(VALUES('Table'[visit_start_date])),
CALCULATE(COUNTA('Table'[Visit Type]))
)
I put that in some table visuals, filtering them by the age of the person, and came up with this from your example data. Try it with your data, and see if you come up with what you're looking for!
This worked perfectly! Thank you so much. :smileyvery-happy: