Divide Annual Savings into Months (as columns) in a Matrix

[JLambs20]

Hello! I'm looking to take an annual savings that is found in a cell for a particular item and then divide that savings into a monthly number.  I'd like to use a matrix where the rows are the items and the columns are all of the months that would contain the monthly savings number.  For example, if item "A" has a total savings of $12000, begins savings on Feb 1, 2021 and the savings ends on Jan 1, 2022, I'd like to see the months across the top of the matrix from Feb 1, 2021, to Jan 1, 2022 and have $1000 in each cell.  The tricky variables here are that each item may (and most likely will) start at different dates.  So, the months across the top have to go from the earliest start date to the latest end date.  I have attached a screenshot as an example: 

Thank you for your help!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[JLambs20]

Hello Ashish!

Unfortunately, my company blocks my ability to get to OneDrive.  Is there another way I could access the file? 

Thanks,
Josh

[Ashish_Mathur · Accepted solution]

Hi,

Attached below my signature.

[JLambs20]

This worked perfectly! Thank you so much!

[Ashish_Mathur]

You are welcome.