Date.IsInPreviousQuarter Function in Power Query

The Date.IsInPreviousQuarter function returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the previous quarter, as determined by the current date and time on the system.

Syntax

Date.IsInPreviousQuarter(dateTime as any) as nullable logical

Example:

Power Query M

let
  Source = Table.FromRecords(
    {
      [Year = "20-07-2024"], 
      [Year = "21-07-2024"], 
      [Year = "22-07-2024"], 
      [Year = "23-07-2024"], 
      [Year = "24-07-2024"], 
      [Year = "25-07-2024"], 
      [Year = "26-07-2024"], 
      [Year = "27-07-2024"], 
      [Year = "28-07-2024"], 
      [Year = "29-07-2024"], 
      [Year = "30-07-2024"], 
      [Year = "31-07-2024"], 
      [Year = "01-08-2024"], 
      [Year = "02-08-2024"], 
      [Year = "03-08-2024"], 
      [Year = "04-08-2024"], 
      [Year = "05-08-2024"], 
      [Year = "06-08-2024"]
    }
  ), 
  #"Changed Type" = Table.TransformColumnTypes(Source, {{"Year", type date}}), 
  Return = Table.AddColumn(#"Changed Type", "Is in Previous Quarter?", each Date.IsInPreviousQuarter([Year]))
in
    Return 

The output will be shown in the following image:

Date.IsInPreviousQuarter function in Power Query