Solved: SELECT Based on User Selection - Page 2

Qiro · 07-26-2022 02:59 AM

I'm using the following expression to reference data from another table:

ANY(SELECT(Asset Log[Hours], AND([_THISROW].[ORS] = [Associate Name], [_THISROW].[Date] = [Date])))

It seems to work intermittently, sometimes showing data correctly and other times showing nothing.

It depends on user selection from a dropdown for the match for [Associate Name] and a date selector for the [Date].

Any ideas what's going doing wrong?

Swoopy

Try this in valid-if of [Date] column,

SELECT(Asset Log[Date], [_THISROW].[ORS] = [Associate Name])

This forces the dropdown to show only valid dates.