How to use Date.IsInNextMonth in PowerQuery
If you want to dynamically be able to identify dates which are in the month after the current month, how do you do that in PowerQuery? The easiest way to do this is to use the Date.IsInNextMonth function, and in this post, we’ll go through how to use this function.
Resources
Symbols
Video Chapters
- 00:27 What other functions work in the same way as Date.IsInNextMonth?
- 00:48 How does the function work and what are the parameters?
- 03:33 Date.IsInNextMonth demonstration in Power BI
- 06:39 Date.IsInNextMonth demo with Date.AddDays
Short On Time?
Instructions
a) In Power Query, create a custom column by going to the ‘Add Column’ tab and then ‘Custom Column;.
b) On the pop up menu, add the new column name
c) In the ‘Custom Column Formula’ box, type in the function name Date.IsInNextMonth. Intellisense will bring up the parameters you need to complete to make the function work, but please also see the slide to the right.
Instructions
Date.IsInNextMonth is part of the Date series of M functions. All M functions can be viewed at Power Query M function reference – PowerQuery M | Microsoft Learn
You must be logged in to post a comment.