Hey
How can I filter the query table within "From" "To" dates, to show only running and next 3 weeks records?
Hey
How can I filter the query table within "From" "To" dates, to show only running and next 3 weeks records?
You have given us two identical tables. Where have you manually mocked up what you want?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The query table ( right one ), not the normal table
its ready just need to filter
Your next line of Mcode is:
Clcik on the drop down arrow in the To column and select "Is In Next"Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
@alansidman This will only show the records will end in next 3 weeks, but it will not show all running records
example, from 25/9/2021 to 30/10/2021, this will run in next 3 week but it will not show, because it will not end in next 3 weeks
explain again I need to show running records+ the records will start in next 3 weeks
Sorry, cannot figure out syntax for your needs. If you can provide the excel syntax if you were doing an if then statement, I might be able to get it. But right now, I don't see the syntax for your needs. Good Luck.
I think this will work but how to go with it?
FILTER : IF "FROM" in the next 3 weeks OR "FROM" >= TODAY AND "TO" <= TODAY
Will work on this later today. Got errands, etc to do.
Alan
Edit: Back and worked on this for an hour with no success. Will ask other for help.
Last edited by alansidman; 09-17-2021 at 09:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks