Forum Discussion

DavidMoss's avatar
DavidMoss
Icon for Advocate V rankAdvocate V
10 years ago

Power Query M filter data by Dynamic Date (PQ not DAX) Start of Month

More as a reference for us than a question which hopefully you will find useful :-)   I was just working on filtering data in Power Query based on the date. I kow you can manually filter your sourc...
Tips and Tricks
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Thanks for sharing this, DavidMoss. I think it is a good solution if we only want to keep the current month data.

 

Best Regards,

Herbert

  • DavidMoss's avatar
    DavidMoss
    Icon for Advocate V rankAdvocate V
    10 years ago

    Hi Herbert, just for confirmation the code would return anything after the first day of the month of the current system's date , including the current month data and anything else in the future.

    I used a similar solution for a Salesforce CRM query to clean out old orders which sales teams often leave in there to ensure only the true active 'live' orders were ETL into the dataset.

     

    With further research i also discovered those DateTimeZone functions which help with to adjust for different time zones from the data sources.