Measure to check if the employees received salary for last three months

[Ramees_123]

I have below two tables tables with below fields. Emp ID relationship exists.

EmpDimension

Emp ID

FactSalary

Emp ID

Salary Date

Salary Amount

I need to know the number of employees for whom the salary credit happend for last 3 calender months.

If I am checking this measure today, then it should show me the count of Employees received salary for Months (Apr, May, June). Salary may be credit or any day in a month. 

Please help.

[v-yalanwu-msft · Accepted solution]

Hi @Ramees_123  ,  

As amitchandak said , You could use EOMONTH(), and I created a simple example：

count =
CALCULATE (
    DISTINCTCOUNT ( [Emp ID] ),
    FILTER (
        ALL ( 'FactSalary' ),
        [Salary Date] <= TODAY ()
            && [Salary Date] > EOMONTH ( TODAY (), -3 )
    )
)

The final output is shown below:  

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

[amitchandak]

@Ramees_123 ,

Try without TI and Date table

Rolling 3 = CALCULATE(distinctcount(Table[Employee ID]),filter(all(Table[Date]), Table[Date] <= max(Table[Date]) && Table[Date] >= eomonth(max(Table[Date]),-3)))