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.
