Month Calculation

[Syndicate_Admin]

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?

[amitchandak · Accepted solution]

@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-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

[Syndicate_Admin]

Worked! Thanks a lot