Check for Value exists one month before from today - Power bi desktop

[santoshrnath]

Hi,

I have a single table with all my workers list in it. There is att_emp_id column and also att_date column. It is a biometric device data.

I need to check if the id is available one month before today. That is i want to find who has joined this month. how do i do it.

 

[v-shex-msft · Accepted solution]

Hi @santoshrnath,

You can try to use below measure to check the id if it joined one month ago:

Is Join One Month Ago=
var currDate=MAX(Table[att_date])
var currId=max(Table[att_emp_id]
Return
IF(CountRows(FILTER(ALL(Table), Table[att_date]=Date(Year(currDate),Month(currDate)-1,Day(currDate)&&Table[att_emp_id]=currId)))>0,TRUE(),BLANK())

Use  att_emp_id and the above measure to create table visual.

Regards,

Xiaoxin Sheng