How to get the data from the 1st of the current month onwards with Power Query T0015

Опубликовано: 20 Ноябрь 2024
на канале: Celia Alves - Solve & Excel

2,827

Having a set of data with dates, how can we filter it to get only the dates from the first day of the current day? We will answer this question using Power Query in Excel for two different scenarios: when the data does not go past today or the current month and when the data includes dates in the future.

-----

Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn:   / celiajordaoalves

Facebook:   / solveandexcel

Twitter: @celia_excel

Instagram: @solveandexcel

YouTube: https:www//   / celiaalvessolveexcel

#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA