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?
Solved! Go to Solution.
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.
User | Count |
---|---|
16 | |
13 | |
8 | |
3 | |
2 |