Help with turning target formula to YTD

[Anonymous]

Hello, I have a dax formula that works well to figure out the monthly target based on the provider start date, however I can not figure out how to get it to total the year to date number. For example if the target is 100 in Jan, 100 in Feb and 100 in March in the sample data this would be for Shan, when I select all 3 months on the filter I would like it to say 300.

Here is the measure:

Monthly Target Hours = var __curdate = TODAY()

var __providerstartdate = MIN('Global Staff Targets'[Provider Start Date])

var __firstdate = MIN(Dates[Date])

var __lastdate = MAX(Dates[Date])

var __daysworked = SELECTEDVALUE('Global Staff Targets'[# of Days Worked Per Week])

var __startdate =

IF(

__providerstartdate<=__firstdate,__firstdate,

__providerstartdate

)

RETURN

DIVIDE(

DATEDIFF(__startdate,__lastdate,DAY),

DATEDIFF(__firstdate,__lastdate,DAY),0

)*(__daysworked/5)*100

Here is some a sample data set:

Provider ID	Provider Full Name	Provider Start Date	# of Days Worked Per Week
1	Shan Smith	November 8, 2021	5
8	Lisa Smith	February 14, 2022	5
21	Katie Smith	March 16, 2022	5

Can anyone help me please?

[amitchandak]

@Anonymous , Not very clear , can you explain with example

refer, if this can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785

Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798

[Anonymous]

@amitchandak 

Apologies for not explaining properly, its my first time here and I am just starting out on Power BI. Thank you for responding. Let me try to explain better:

I am trying to find the target hour per month for each employee, so the formula currently takes the start of the year if the employee start date is before Jan 1 , 2022 however if the employee start date is after Jan 1, 2022 then take the start date to pro-rate the target. Additionally, each employee works a particular amount of days .5 - 5. 

So, the target is 100 hours for each month for an employee that works 5 days. If the employee works 3 days and started Jan 1st their amount would be 60 each month.

If the employee started Jan 15 then their hours would be 50 for Jan and 100 for the rest of the year if they work 5 days if they work 3 days it would be 30 for Jan and 60 for the rest of the year.

The formula does calculate each month correctly if I have a slicer and select the respective months however if I select multiple months it does not add up the target so if I selected Jan, Feb and Mar it should be 300 for an employee that works 5 days and started Jan 1st. So, I am asking for help to see if anyone knows how to do that please?