Leave Dashboard for Custom Sprint dates from Excel data

[srinivasjr04]

Hi I want to create a dashboard with Bar chart showing the number of leaves taken by each employee sprint wise. I have a sprint table in PowerBI with Sprint ID, Start Date, End Date Like below 

Employee Leave data is captured in excel in the following format for each month one Sheet (Sheet is named with Short form of Month name with first 3 letters) and every calendar year new excel workbook 

I need to map the leave data to the sprint periods and calculate the number of leaves taken by each employee per sprint in Bar chart.

Request to help me to acheive this.

Thanks

Srinivas

[danextian]

Hi @srinivasjr04 

Please provide  a workable sample data (not an image), your expected result from the same sample data and the reasoning behind. Also, what are those numbers in the first row of your second screenshot? Please refer to this post on how to get question answered quickly. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...