GET THE TEAM ACTIVE PER MOUNTH

[Anonymous]

Hi, I have the table below.

I need to build a graph that gives me the number of teams that are active for a given month that is on the slicer. I thought to be active in a certain month, the opening date is greater than the selected date and the closing date is empty or greater than the selected date. But I'm not able to build the graph like that.

Help me please.

[amitchandak · Accepted solution]

@Anonymous , please refer to my HR blog, seems similar problem

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

https://www.youtube.com/watch?v=e6Y-l_JtCq4&t=321s

[AllisonKennedy]

@Anonymous  Do you have a Dim Date table? If you do, you should be able to apply the concept of DAX Approximate lookup: https://excelwithallison.blogspot.com/2020/06/dax-approximate-lookup.html

Let me know if that makes enough sense, but if you want more help applying to your data. 

https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

[Anonymous]

Yes, i have a dim date.