Dynamically shown Monthly MTTR

[KarinaK]

Hi! Could anyone help calculate MTTR dynamically so it could show from start date till finished date how much time was spent each month?

e.g:

I have these columns in a fact table:

TicketNumber

Created_date

Resolved_date
MTTR (which is Resolved_date-Created_date) in hours

and also Calendar autogenerated table

They have two relationships:
Date-Created_date (active)
Date-Resolved_date(Inactive) 

You can see that it only shows the first Created month and total MTTR, I would like to show how much time it was spent in each month from created date till resolved date. 

like this:
TicketN 2 (Created: 02 Jan 2023, Resolved: 15 Nov 2023)
January 2023: 720.22 hours

February 2023: 672.21 hours

March 2023: 744.23 hours

April 2023: 720.22 hours

May 2023: 744.23 hours

June 2023: 720.22 hours

July 2023: 744.23 hours

August 2023: 744.23 hours

September 2023:  720.22 hours

October 2023: 744.23 hours

November 2023:  360.11 hours

Would really appreciate the answer^^

[lbendlin]

Needs much more details.  What are your working hours, what are your weekends and holidays?