Forum Discussion
Responsive ResidentHow best connect calendar table with a Table with multiples Dates column
romovaro , if you want to connect with multiple dates make sure none of them have a timestamp. Join them with date of date table. One join will be inactive you can activate using userelationship
Power BI: 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/fvgcx8QLqZUIn case you need workday diff, you can use networkdays
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
Super Userromovaro , if you want to connect with multiple dates make sure none of them have a timestamp. Join them with date of date table. One join will be inactive you can activate using userelationship
Power BI: 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
In case you need workday diff, you can use networkdays
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c