Query M code adding Custom Column with conditions 'Contains'

[jeongkim]

Hi,

Please help,

I would like to add custom column that

1. if 'Attribute' does NOT contains "_2" then just copy the first 4 letter from "Source.Name" which says the year of the cell 

2. if 'Attribute' does contains number "_2" then plus 1 onto  the first 4 letter from "Source.Name".

e.g.

Row1~10 new custom column should be 2023

Row11~20 should be 2024(2023+1) because its values of "Attribute" contains "_2"

[bhanu_gautam · Accepted solution]

@jeongkim , Use this in custom column

m
= if Text.Contains([Attribute], "_2") then
Text.From(Number.FromText(Text.Start([Source.Name], 4)) + 1)
else
Text.Start([Source.Name], 4)

[jeongkim]

Thanks for prompt help, it works!