Forum Discussion
Solved
Power Query - Excluding current month
In the pursuit of precise and truthful data visualization, it sometimes becomes necessary to omit partial data that may not offer a complete picture. A common scenario where this practice is appl...
Or, more simply:
Table.SelectRows(PreviousStep, each not Date.IsInCurrentMonth([Date]))Pete
BA_Pete
Super User
Super User
Or, more simply:
Table.SelectRows(PreviousStep, each not Date.IsInCurrentMonth([Date]))
Pete
Great job Pete, it is brand new function. According to the Power Query M documentation: https://learn.microsoft.com/en-us/powerquery-m/date-isincurrentmonth, the Date.IsInCurrentMonth function was created on July 19, 2023.
- BA_Pete
No, that was the date the article was last updated.
Date.IsInCurrentMonth has been in the M language spec for many years.
Pete
