[FONT="]Hi,[/FONT]
[FONT="]In my data table, I have an amount as well as a start date and a finish date. eg $100,000, April 1, 2018, November 15, 2018.[/FONT]
[FONT="]I would like to calculate an allocation of the amount on a straight line basis for each month between the start and finish date using a pivot table. eg. April should be 30/229 X 100,000 = 13,100. I know I can do this directly in excel using if statements, but would prefer a more elegant solution, preferably using a pivot. FYI, I am an intermediate pivot user and have some familiarity with Power BI/DAX, etc. Thank you[/FONT]
[FONT="]In my data table, I have an amount as well as a start date and a finish date. eg $100,000, April 1, 2018, November 15, 2018.[/FONT]
[FONT="]I would like to calculate an allocation of the amount on a straight line basis for each month between the start and finish date using a pivot table. eg. April should be 30/229 X 100,000 = 13,100. I know I can do this directly in excel using if statements, but would prefer a more elegant solution, preferably using a pivot. FYI, I am an intermediate pivot user and have some familiarity with Power BI/DAX, etc. Thank you[/FONT]