In an expression I have a unique value and I need to pull a specific field value from a table. How can I do this? I tried looking at the peek function (I know peek can only be used in the script) and at the previous function but I cannot figure it out? If I cannot do it in an expression I am willing to do it in a script and save it in a variable.
Solved! Go to Solution.
This is one way to do it in the script
(ooxml, embedded labels, table is MultiCalendar);
LOAD [Week Count]
Where [Transaction Date] = Today();
LET vCurrWeekCount = Peek('Week Count');
DROP Table Temp;
What I am specifically doing is trying to use Today's date to find a specific week_count in my CalendarTable and then use that in set analysis to filter results.
Remember I am new and I am trying to think of solutions. so I have been searching and using a lookup value in my script to set a variable seems like it might work. Do you think that would be a good solution?