Forum Discussion
Dax formula
Hi guys,
need some help from you clever people!
I have a column with a budget in it "FY23" and I need to look at the start dates and end dates in two other columns and calculate a monthly budget over the months covered by the start and end dates based on work days only. I would then need to know how I may then insert other columns to show the values for say July and August etc etc
I have some staff where they are for a total 12 months but others are only for say 6 months etc hence why I am using the start and end date column etc
appreciate any help as I am new to DAX
Michael
3 Replies
Hi Anonymous ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin YuHi 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