Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance 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 |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |