Calculate allocation percentage based on working days

[Apbiuser12]

Hi All,

I want to create a table visualization, with name of each employee and allocation percentage by month(only consider working days) and later also need to consider the holidays)

Output table with – Employeename, Month and allocation percentage à ability to slice by month.

Also, if possible, view the allocation by year or YTD

I have three tables in my model –

Dim_date – date columns

Dim employee – Name, country  and first working date,

Fact_project allocation – empname, startdate, end date , allocation perc( value from 0.1 to 1)

I have attached sample data for reference, please suggest.

So as an output - 

Dec Rocky 50%

Jan Rocky 100%

..

Please let me know for additional questions.

I have the sample PBIX also, Not sure how to attach the same.

[amitchandak]

@Apbiuser12 , with these approach you should be able to get monthly data summed up

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

For work day you need measure like

sumx(values(Table[empName]) , calculate( networkdays(min(Date[Date]), Max(date[Date]),1) ) )

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c