New custom column, best way to merge ?

[Anonymous]

Hi awesome ppl,

I am currently using visual filter which works but could anyone please suggest best way to get this output column?

Student ID	Type	Yearly pay		Output expecting
D00123	Daily	Other		Daily
S00124	Seasonal	Other		Seasonal
M00125	Seasonal	Other		Seasonal
M00126	Monthly	Yearly		Yearly
M00127	Monthly	Other		Monthly
D00128	Daily	Other		Daily
D00129	Daily	Other		Daily
S00130	Seasonal	Other		Seasonal
D00131	Daily	Other		Daily
M00132	Monthly	Yearly		Yearly
M00137	Monthly	Other		Monthly
D = Daily
S = Seasonal
M = Monthly

Thank you in advance

Van2050

[drewlewis15 · Accepted solution]

If I am understanding the logic behind the expected outcome then:

Custom column via the Power Query Editor: if [Yearly pay] = "Yearly" then "Yearly" else [Type]

New Calculated column: Output = IF('Table'[Yearly pay] = "Yearly", "Yearly", 'Table'[Type])

[Anonymous]

Both work like a charm, Thank you so much for your help.

Have a great weekend!