Open orders per person per month

[IAM]

Hi all,

I have doubts it is possible how I wish to have something, but I´m trusting if it is possible, someone here will know 🙂

Here you can download a sample file: 

https://www.dropbox.com/s/p1utrkw1zj7aga1/Per%20person%20per%20month%20open.pbix?dl=0

Each persons has a scope of orders. I know a start and a finish date. Now I want to see in the past months when an order was open or not. 

I can make a table for each person and each month to see all orders with a startdate in that month, but is it possible to have a measure that show the open orders in that months?

Some snapshots of the sample file:

[amitchandak · Accepted solution]

@IAM , refer if my blog attached file of similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[IAM]

Thanks @amitchandak you are awesome and this is very helpful!

One more question though. When I make a relation to the start date and the end date to the date table, the start and end columns change from a date value.

So now my slicers with the start date cannot be in the relative date option anymore.

I also cannot use data[date]  for the relative option, because start and end date are not in the same month.

I found a solution! I duplicated my start and end column to make the relation with.

My date slicers remain intact 🙂

If anyone know a better solution, happy to hear.