Forum Discussion
Solved
Help with DAX - Count Using two coluns Date as Filter
So, I have a data set that is compose of a List of Tasks to do that can be recurrent. I want to evry task that is Conclud, and that is program to end this month so I try: Concluded Tasks ...
danielpcamara , Not very clear, what you want to achieve. But the file attached after signature and HR Blog should help you https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Thank you amitchandak. The "Current Employees" was what I Needed.
I solve with this:
Concluded Tasks = IF(
[Expected Tasks] > 0,
CALCULATE(
COUNTX(
FILTER(
Tasks,
LEFT(Tasks[Expected Date],6) = LEFT(MAX('Calendar'[Data_id]),6) && /* Filter Tasks of this month
RELATED('Calendar'[Ano]) = MAX('Calendar'[Ano]) &&*/
Tasks[Conclusion Date] <= MAX('Calendar'[Data_id])
),
Tasks[Task]
),
CROSSFILTER(
Tasks[Expected Date],'Calendar'[Data_id],None
)
)+0,
BLANK()
)
And I got this:
I try to upload in the question what I was expectin 4 times, but does not work, so I will try here to: