Forum Discussion
Removing few characters from rows
Thank you so much for the help everyone. But in a column that has both Android and IOS following the versions. I just want to create a column that specifies, whether it is an Android or an IOS operating system.
So my results should something like this:
IOS
IOS
IOS
Android
Android
IOS
Instead of:
ios 8.3 (0.03K)
IOS 9.3.1 (1.49 k)
IOS 10.1
Android 5.0.1
Android 1.4.2 (OK)
IOS 9.3.2 (OK)
Is there a DAX query for that, or any other way to do it?
Community ChampionAnonymous
Hello, To understand your Question, What is the difference between my answer and the result expected?.
Hello, I tried to do what you suggested and succeeded. Thank you so much for your help. Really appreciate it. :cathappy:
I just wanted to understand, what if there were Blank values in the column and I want to include that along with Android and IOS. Is there a way to do that too?
- Vvelarde
Anonymous
You can add a new condition in the Conditional Column to IOS. ---> IOS And ELSE Condition leave blank or enter "Other OS".
Thank you so much for sharing the information. I really appreciate it