Expression stopped working in virtual column

One of my virtuals stopped working. I haven’t touched it. Similar expressions are working fine accessing the same table, id’s, etc…

It’ comes back fine in the editor, when I test it zero results in return…am I missing something? Thanks!

Here it is

SELECT(TimeCards[TimeCardID],
AND(
([Installer Name]=[_THISROW].[Employee]),
([Task Date]>=[_THISROW].[Start Date]),
([Task Date]<=[_THISROW].[End Date])))

Where does it not work? In what way doesn’t it work?

It sends back nothing, blank
Before it was sending back all of the columns in the table, now…nothing.

working…

1 Like