Help!! I have 2 comumns. 1 for Student name(...

[Abu_Md_Moniruzj]

Help!!

I have 2 comumns. 1 for Student name(Name) & 1 for log in (DateTime). I hv a view named’Not loged in Today’. What will be expression for this view, so that it will get me the all the students who are not loged in today??

Urgent?

[Aleksi_Alkio]

Do you have another table where you have all user names?

[Abu_Md_Moniruzj]

Yes

[Aleksi_Alkio]

DATE(MAX(SELECT(LoginTable[DateTime],[Name]=[_THISROW].[Name])))<>TODAY()

[Abu_Md_Moniruzj]

Not working!! Error in expression ‘[_THISROW].[কর্মকর্তার নাম]’ : Unable to find column ‘_THISROW’

I used this expression in show _ if:

DATE(MAX(SELECT(বহিরাগমন রেজিস্টার [লগ ইন],[কর্মকর্তার নাম ]=[_THISROW].[কর্মকর্তার নাম])))<>TODAY()

Translate

[Abu_Md_Moniruzj]

@Aleksi_Alkio

help!!

Translate

[Aleksi_Alkio]

Are you using this formula in Users table?