Convert Year Quarter format into date format

Hi Anonymous,

to format from 1Q06 to 2016 Q1 use:

let
    Source = "1Q06",
    QuarterNr = Text.BeforeDelimiter(Source, "Q"),
    Year = "20" & Text.AfterDelimiter(Source, "Q"),
    NewFormat = Year & " Q" & QuarterNr
in
    NewFormat

And to convert from 1Q06 to the last day of a quarter use:

let
    Source = "1Q06",
    QuarterNr = Number.FromText(Text.BeforeDelimiter(Source, "Q")),
    Year = Number.FromText("20" & Text.AfterDelimiter(Source, "Q")),
    StartOfYear = #date(Year, 1, 1),
    EndOfQuarter = Date.AddDays(Date.AddQuarters(StartOfYear, QuarterNr), -1)
in
    EndOfQuarter