The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have been struggling with visualizing data regarding attrition rates.
I was trying to visualize the total hired employees by a slice filter of dates. I have figured out this by using another method; counting the employee_Id but still, I am wondering why the other method was not working.
Data table: HRDataset, Calendar
Column :
* HRDataset - Employee_id, Hired_date,Terminated_date, Terminated_Status
* Calendar - made by DAX using
What I was simply thinking is to calculate the count of the date of hire of an employee when the date is less than the filter's date. Do you think this got error because of my idea????
Thanks
User | Count |
---|---|
29 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |