I have a tablix that displays every day from today to one year in the future. It shows incoming inventory and outgoing customer orders. It calculates when to place a new inventory order based on quantity on hand.

What I need to add is a default estimated monthly usage on the LAST DAY OF EVERY MONTH. How would I do this for 12 end of month values? I see how to find current end of month or last day of last month but not last day of every month using a date dimension table.

tablix