unable to edit a imported dataset.

[Anonymous]

Hello folks,

I have imported a dataset and I need to split the category column below into 2. I would like to have another column only with the values highlighted in the second pic. The issue is that I cannot transform it in Power Query because it is a template. Is there a way to create a measure or calculated column to split this field?

Thank you.

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You can create a column like below:-

column  = if(CONTAINSSTRING([category], "Planned Maintenance"),"Planned Maintenance")

Thanks,

Samarth

[Anonymous]

Thanks a million, @Samarth_18 ! It was really helpful.