Dax formula

Hi Binbin Yu,

thank you very much for reading my post and offering some help.

Below is an snippet of what the main data looks like at this stage.

so what I am hoping to do is the following:

1) Include a series of coumns which are the months of the financial year commencing with July and going through to June

2) I am then wanting via a Dax formula to calculate the monthly forecast budget based on looking at the full year budget (FY23) and then the start and end dates for the position and divide this budget up covering the days in the month between the months to where the staff member is to be employed for example on the second line the person is not due to commence until 28/1/23 so I want to align the budget of $83,432 over the months from that date to 30 June 23. In the first line the perosn started on the 1/7/22 so that persons budget is split ovre the full 12 months.

3) I then want to also include a year to date budget column where we would look at the say todays date and then add the months up to today ie July, August and septembre to give you a year to date budget for each line. That way I can see if I am under on some lines and ovre on others and provide an accurate report.

I hope this makes sense?

Thanks for your time

Michael