Forum Discussion

MIrlam's avatar
MIrlam
Frequent Visitor
4 years ago
Solved

Calculating Occupied beds across multiple months

Hi all   I have a table with date of admission and date of discharge in it. I can calculate the bed occupancy quite easily for people who arrive and leave in the same month. I have custom columns t...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  MIrlam ,

    Here are the steps you can follow：

    1. Create calculated column.

    Flag = DATEDIFF(EOMONTH('Table'[date_hospitalized],-1)+1,EOMONTH('Table'[date_Discharged],0),MONTH)
    day =
IF('Table'[Flag] >=2,DATEDIFF('Table'[date_hospitalized],'Table'[date_Discharged],DAY),0)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

MIrlam , A measure like

Countrows(filter(Table, datediff([admission date],[date of discharge],1) > 0 ))

 

or

 

Countrows(filter(Table, Eomonth([admission date],0)<eomonth([date of discharge],0)  ))

  • MIrlam's avatar
    MIrlam
    Frequent Visitor
    4 years ago

    Thanks but I don't think I want countrows, I tried it using the first expression and it just returned 2884 in every row in the column.