Forum Discussion
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
- AnonymousNot 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
Column1 Column2 Expected output
Column1 Column2 Expected 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.