Forum Discussion

EmployeeOM's avatar
EmployeeOM
Frequent Visitor
2 years ago

Need help with DAX tables - Repost with examples

So the situation itself is quite complicated, so please bear with me for a bit. So I have two tables that I merged them together with DAX, this resulting table has informations like Ticket ID, ID RAN...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
2 years ago

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

  • EmployeeOM's avatar
    EmployeeOM
    Frequent Visitor
    2 years ago

    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