Here’s a dataset with 3 columns – Patient Name, Date of admission and Duration (days).
|Patient||Date of admission||Duration (day)|
The objective is to split the hospitalization per patient into different months to determine each month’s revenue accrual. The expected result is
|Length of stay||Month|
I have solved this problem with the help of Power Query and PowerPivot. You may download my workbook here.