Hello,
I have a set of data that runs by ( flight Date) currently the date comes from a report that includes dates for over 6 months up to the date the report is run I.E (today + 1 week).
I need to filter this data to only show the last 2 months and include the next 1 week inclusive of the current month, however Power query only filters last 2 months and ignores anything from the current month., I have tried to add conditions but it keeps returning blanks.
Is there a way to filter it this way?
Please let me know, thanks in advance.
I have a set of data that runs by ( flight Date) currently the date comes from a report that includes dates for over 6 months up to the date the report is run I.E (today + 1 week).
I need to filter this data to only show the last 2 months and include the next 1 week inclusive of the current month, however Power query only filters last 2 months and ignores anything from the current month., I have tried to add conditions but it keeps returning blanks.
Is there a way to filter it this way?
Please let me know, thanks in advance.
