Forum Discussion

Goforit5's avatar
Goforit5
New Member
5 years ago

Per Patient Day - Column Calculation

Hi there, I'm fairly new to PowerBI, but I have a question about adding a column of per patient day (PPD) data on an income statement. In Skilled Nursing, we analyze both dollar amounts on the income statement and also those same dollar amounts divided by the number of patient days a skilled nursing facility had per month. Each month has a different number of patient days and each facility has a different number of patient days. 

I'd like to figure out how I can take my "normal" income statement column with dollar amounts and duplicate that side-by-side with a second column that divides those amounts by the total patient days for the month/period/facility being viewed. 


Example: The income statement shows we spent $1,000 on food this month - so this tells me the total spend. We don't really know if this is low, high, or normal unless we put that side-by-side with the PPD figure. If we had 239 patient days that month, then we would say our food PPD for the month was $4.18 (1,000/239). I'd like the income statement to have the $1,000 in column 1 and the $4.18 next to it in column 2. 

I will be posting the patient days to the GL in Business Central as a unit account so the dollar data and this patient day data live in the same place. 

Thank you for your help in advance and let me know if their are any clarifying questions I can address. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Goforit5 ,

     

    My apoloizes for my delayed response.

     

    Please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

     

    Just like as follows

     

    Sample table

    Column1Column2
      

     

     

    Expected output

    Column1Column2Expected output
       

     

     

     

    Best Regards,

    Stephen Tao

     

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