Forum Discussion
GET THE TEAM ACTIVE PER MOUNTH
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.
Anonymous , please refer to my HR blog, seems similar problem
3 Replies
- AllisonKennedy
Community Champion
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
- amitchandak
Super User
Anonymous , please refer to my HR blog, seems similar problem
