need the dax logic

[sunil222]

Need the dax logic when employee terminates on particular month , from that month onwards head count shows as 0 , before the terminating month shows as 1 , in this eg ravi terminates jun 23 from jun 23 onwards hc shows as 0 before that dates shows as 1

please give the logic for head count of emp . data is as below format

                                                      23-Apr    23-May   23-Jun   23-Jul   23- aug    23 -sep

emp      doj        lwd                        HC             Hc            HC         HC          HC           HC

ravi  14-0ct-21 01-jun-23                  1               1               0            0               0           0

[v-jiewu-msft · Accepted solution]

Hi @sunil222 ,

If I understand correctly, the issue is that you want to use the DAX formula to count of emp. Please try the following DAX formula and check if they can solve your problem:

1.Create the two simple table.

2.Create the new measure.

Measure = IF(MAX('Date table 2'[Date]) < MAX('Table'[Iwd]), 1, 0)

3.Select the matrix visual. Drag the emp to the Rows, drag the Date table Date to the Columns and drag the measure to the Values.

4.The result is shown below.

Best Regards,

Wisdom Wu