Variable in Set Analysis Not Capturing Data correctly

Question

I used the following set analysis to capture the next date on column Next Repair Date

=DATE(MIN({<[Next Repair Date] = {">=$(=TODAY())"}>} [Next Repair Date])).

Next I stored the expression into a variable and used another set analysis to capture column Car Repair Maintenance Service based off of the Next Repair Date

=only({<Date={'$(=$(NextRepair))'}>} [Car Repair Maintenance Service])

However, I get nothing when I apply this expression.

What is causing my set analysis to not capture any data? It show capture data Engine Modifications based off this script.

Answer 1

It's hard to say because we don't know how your [Date] field fits into this but in your Car Repair Maintenance Service expression...

=only({<Date={'$(=$(NextRepair))'}>} [Car Repair Maintenance Service])

...you may be running into a problem with the formatting (or lack thereof) of your '$(=$(NextRepair))' expression. You may want to try doing '$(=Date(NextRepair, 'M/D/YYYY'))'.

It'd be good to get more context on what you're trying to achieve here, though.