Multiple date columns with one date table

[Anonymous]

Hello!

I have a question about the way the dates are connected to the date table. I have a dataset like the below that is connected to a date table with Open Date. This connection works fine. The question I need answering and I can't get right is: How many projects were opened in February and how many of them were closed? I would pick January in the date table, but it would only show me the open projects because it's the one connected to the date table.

Project ID	Open Date	Closed Date
fasdgfads	01-Jan-20	03-Mar-20
gsdagads	02-Feb-20	04-Mar-20
gasdghff	03-Feb-20	05-Mar-20

I thought of potentially creating a separate table with the closed dates only, but not sure if there is an easier solution.

Thanks!

Jon

[amitchandak · Accepted solution]

@Anonymous , You need to create a common Date table and join both with that, One active and one inactive realtion. Use userelation to activate them as per need.

Refer: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970