Forum Discussion

RyanJEngLegacy's avatar
RyanJEngLegacy
New Member
3 years ago

Average Daily Census

Hello All,

 

I am fairly new to Power BI. I am trying to compute the Average Daily Census for a healthcare provider. We have a patient count per day which changes often but the importance would be the average over time. I am having trouble coming up with the DAX coding for that.

Any help would be greatly appreciated.

Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    RyanJEngLegacy , A measure like

     

    AVERAGEX(Values(Table[branch]), calculate(AVERAGEX(values(Table[Date]), calculate(Sum(Table[Census])))))

     

    or

    AVERAGEX(Values(Table[branch]),[Average Daily Census measure])