Expression stopped working in virtual column

Rod
Bronze 3
Bronze 3

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])))

0 3 141
3 REPLIES 3

Steve
Platinum 4
Platinum 4

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.

Rod
Bronze 3
Bronze 3

working…

Top Labels in this Space