Conditional Column

[Warpug]

I have a column that is populated with dates from 2018-current date. For business reasons I would Luik to add a column that looks to the value in the cell with the date which is in this format mm/did/yyyy and do the following:
if year=2018 then “Made in 2018”
if year=2019 then “Made in 2019”
the rest I would like to have a value returned that provides me with the quarter and year based on the date field.
Q1 2020 or 2021 depending on the year
Q2 2020 or 2021 depending on the year
Q3 2020 or 2021 depending on the year
Q4 2020 or 2021 depending on the year
this is relatively simple in excel, but in Power query I’m having a hard time with it.

 

[alansidman]

Book13
	C	D
1	Column1	Custom
2	6/2/2018	Made in 2018
3	7/24/2019	Made in 2019
4	11/6/2018	Made in 2018
5	3/10/2018	Made in 2018
6	6/18/2020	Q2 2020
7	7/6/2021	Q3 2021
8	4/10/2020	Q2 2020
9	2/7/2018	Made in 2018
10	2/2/2019	Made in 2019
11	12/5/2019	Made in 2019
12	6/25/2020	Q2 2020
13	12/17/2018	Made in 2018
14	3/27/2020	Q1 2020
15	3/10/2020	Q1 2020
16	5/12/2021	Q2 2021
Sheet1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}),
    #"Inserted Year" = Table.AddColumn(#"Changed Type", "Year", each Date.Year([Column1]), Int64.Type),
    #"Inserted Quarter" = Table.AddColumn(#"Inserted Year", "Quarter", each Date.QuarterOfYear([Column1]), Int64.Type),
    #"Changed Type1" = Table.TransformColumnTypes(#"Inserted Quarter",{{"Quarter", type text}, {"Year", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each if [Year]= "2018" then "Made in 2018" else if [Year]= "2019" then "Made in 2019" else "Q" & [Quarter] & " " & [Year]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Year", "Quarter"})
in
    #"Removed Columns"