Forum Discussion
Filter a query based on a another table
Hi AnaBraganca ,
I think you can use Parameter in Power Query.
Then you can choose Date Filters and select Before.
Finally you can get the whole days before what you need.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I'm trying to avoid creating another table.
What I'm trying is for this filter to be each [Data] <= the latest date of the Dat1 column (second picture). But this second part of the code is the one I'm struggling with.
This is the table with the date I want to filter with.
In this case, I want the code to filter by 30-06-2023, which will change when a new row is added.
Hi AnaBraganca ,
I think you can use Parameter in Power Query.
Then you can choose Date Filters and select Before.
Finally you can get the whole days before what you need.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I've tried this before going for the Advanced Editor option, but I could never get the parameter to automatically get the last date of the Existencia table.