cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JLambs20
Helper I
Helper I

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

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: Monthly Savings.jpg

Thank you for your help!

1 ACCEPTED SOLUTION

Hi,

Attached below my signature.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello Ashish!

 

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

 

Thanks,
Josh

Hi,

Attached below my signature.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

This worked perfectly! Thank you so much!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.