Looking to extract only YEARS from specific column

[Anonymous]

Hello everyone,

Morning!

I had a dataset in powerBI, where it looks as follows

Numbers	Exams
1	DAX-100-PowerBI-2018-2021
2	20-DAX-200-PowerBI-2021
3	201-DAX-205-powerBI-2019-2020

I would like to mention that, every row in Exam's column ends with years and I tried splitting column by delimiter (But, all the data was not in the same format, But all of them ends with years)The result should look like

Numbers	Exams	Years
1	DAX-100-PowerBI-2018-2021	2018-2021
2	20-DAX-200-PowerBI-2021	2021
3	201-DAX-205-powerBI-2019-2020	2019-2020

Looking forward for responses.

Thank you. 

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I can clearly understand your requirement, you can try to create a calculated column like this:

Years =

IF(

    ISERROR(left(RIGHT([Exams],6),1)+1),

    RIGHT([Exams],4),

    RIGHT([Exams],9))

And you can get what you want, like this:

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , a new column in DAX

Year =

var _pos = search("PowerBI-",[Col],,0)

return

right([Column], len([Column] -(_pos+8))

[Anonymous]

Hi Amit, 

sorry, I didn't get what that mean - could you please elaborate the measure and the measure says that we are searching "PowerBI-". But in my case I will have two different types of text either "PowerBI" or "Power flow". 

Thanks Amit.

[amitchandak]

@Anonymous , I try to get the location of - after power bi and use that.

What you do first check if it has power bi or power flow and the change logic .

ALso this a new measure

Year =

var _pos = search("PowerBI-",[Col],,0)

return

if(_pos>0, right([Column], len([Column] -(_pos+8)),  right([Column], len([Column] -(_pos+11)) )

[Anonymous]

Hi Amit 

I am getting an syntax error.

Thank you so much for following up the error. 

Really appreciated-

Thanks