Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / How to pull a Time-Off...
Human Resources forum
Suggested answer

How to pull a Time-Off Balance Report for all employees?

Posted on by 73

Hi, 

In our old system we were able to pull a time off balance report which you were able to filter the date e.g. October 1st – 31st and the leave type (e.g. Annual Leave). It will then show the current balance of the employees leave at the start of the month , the amount they will accrue that month, the amount they have used (if they have applied for leave), any scheduled leave, adjustments, and an ending balance for the month. See below:

pastedimage1666234160795v1.png

Is this possible to recreate in dynamics HR and pull the balance report for all employees in the business? has anyone made something like this in the excel workbook?

Thank you!

  • HRHarry Profile Picture
    HRHarry 73 on at
    RE: How to pull a Time-Off Balance Report for all employees?

    No worries thanks Parag Chapre , I'll post on the power bi community

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,268 Most Valuable Professional on at
    RE: How to pull a Time-Off Balance Report for all employees?

    You need to create a measure and date table to achieve this. You can try to put this on Power BI community.

  • HRHarry Profile Picture
    HRHarry 73 on at
    RE: How to pull a Time-Off Balance Report for all employees?

    Hi Parag Chapre ,

    I followed your blog on how to create the leave table in powerbi using the leave bank transaction table in a matrix table on powerbi.

    pastedimage1666236663328v1.png

    However, I want to be able to add a date filter and my table to show the values like the example I screenshotted in my original question.

    pastedimage1666236845865v2.png

    If I was to add a date filter for the month of October - the this only shows the accrual amount for that month, whereas our old system showed, the employees current balance, the accrual that month - the total at the end of the month and any time off request amounts that had been made. 

    Would you have any guidance on how to recreate this? I think I have the foundations from your example ....I just don't know how to make it similar to our previous report. 

    Thank you!

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,268 Most Valuable Professional on at
    RE: How to pull a Time-Off Balance Report for all employees?

    Hi Harry,

    You can use Dataverse connector in Excel and use leave & bank transaction table with some leave tables. I created with Power Bi but it is same with excel using Power query.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans