Forum Discussion
Need help with DAX tables - Repost with examples
EmployeeOM , What I would do in such case, I create a new start Date
New start Date =
coalesce(
maxx(filter(Table, [Ticket] = earlier([Ticket]) && [Rank] = earlier([Rank]) -1) , [End Date])+1, [Start Date])
refer if needed
For Business Hours
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Business Days
Calculating Business Days with and without NETWORKDAYS DAX Function | 2023 Guide: https://www.youtube.com/watch?v=Qs03ZZXXE_
Active Tickets
HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Thanks for your reply! However that did not solve my problem /:
The issue comes that whenever I make those in between dates it just ignores that new date added