Forum Discussion
Solved
Take value from latest date in PQ
Hi all, I have a question about fetching a target that changes with time. I have two tables: the first one has the StartDate for each target output. Users can input a newer date in this table and...
You could merge the target query into the date query, expand the target value and then fill up to replace the null values. All dates prior to the intial target date will be left as null.
jgeddes that's actually an elegant and simple solution. Thank you !