Forum Discussion
Solved
Rolling vacation accrual help using either DAX or PowerQuery
I'm new to power BI and have the following problem I'm trying to solve. My company operates a vacation accrual that stops when a limit has been reach and will recommence once the employee takes a va...
SteveK66 - Please see attached pbix. Some of the key points in the Power Query solution are:
1. Using a function to run a process for each employee.
2. Using List.Accumulate to process month-to-month.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
SteveK66 - Please see attached pbix. Some of the key points in the Power Query solution are:
1. Using a function to run a process for each employee.
2. Using List.Accumulate to process month-to-month.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
I also appreciate Kudos.