Forum Discussion
Month Calculation
Hello, I have the need to create a bar chart where the x-axis is the months of the year, the y-axis corresponds to events that happen in those months, what I don't do is the following:
There's a start date for a problem for example June, and it has a possible fix date in October and it was finally fixed in December (in that same year), so the chart would show a bar in the month of June (when the problem started and was recorded), a bar for each month in which it wasn't fixed, In this case, a July, August, September, October, November, and even December bar would appear. How can I make this calculation? How did that measure create that if the settlement date is not the same as the estimated date, it will be displayed in those months until the settlement date is met?
Syndicate_Admin , seem like very similar to Active employee in HR
refer blog and files attached
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
2 Replies
- amitchandakSuper User
Syndicate_Admin , seem like very similar to Active employee in HR
refer blog and files attached
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- Syndicate_AdminAdministrator
Worked! Thanks a lot