Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
jgulliver
Frequent Visitor

Monthly breakdown of staff leave based on Start Date and End Date

Hi,

 

I have been a PowerBI user for a while but not very advanced so I can be called a newbie. I have been working on a dashboard to see if there is a way I can provide a visualisation of the number of employees who are on leave on certain days of the month or even on a monthly basis but the only dates I can work off with are the Start and End Dates provided as it will be too much to get the staff to enter their leave dates for each day that they're on leave.

 

I've already added a column to give me the total of leave days per leave type but would also be good if I can get a visual on the this breakdown per month.

 

Any help will be greatly appreciated.

0 REPLIES 0

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors