Date.IsInNextNQuarters
This function checks if the provided date and time value (dateTime) falls within the specified number of upcoming quarters based on the current system date and time. It is important to note that the f...
This function checks if the provided date and time value (dateTime) falls within the specified number of upcoming quarters based on the current system date and time. It is important to note that the function will return false if the dateTime value is within the current quarter. Parameters: dateTime - a date, datetime, or datetimezone value to be assessed. quarters - the number of quarters to consider.
Verify if the quarter following the current system time is within the next two quarters.
Utilizing Power Query function MDate.IsInNextNQuarters, the code determines if the quarter after the current system time is in the next two quarters by adding one quarter to the current local date and checking if it falls within the subsequent two quarters.
The output of this operation should return true if the quarter falls within the specified timeframe.