Search column name headers by name (like)

[Trabka]

Hi there, I am searching advice how can I find column name by the header where I know the header partially.

For example:

I have one column header called "Calculation XXX Jan", and on some point in time later there will be new column added "Calculation XXX Feb" and so on.... there can be a lot other tables with different names added in between so they are not next to each other or even the last one.

How can I find that last column name knowing that only "Calculation XXX" is common header name string ? Sorry if this is obvious but couldn't find the answer also unpivot didn't work for me. Thanks

[Trabka]

Thanks @Vijay_A_Verma ! Works for me. 

[Vijay_A_Verma · Accepted solution]

Use this to find last column names starting with "Calculation XXX"

= List.Last(List.Select(Table.ColumnNames(Source),(x)=>Text.StartsWith(x,"Calculation XXX")))