I have following Data-set
Go to Solution.
Hi @RAHULBANDI ,
All values on your data column has the same start?
There are multiple ways to achieve your DATA1.1
you can do like
if Text.Contains(Text.Upper([DATA]), "RIGHT ISSUE")
then "Right Issue"
View solution in original post
If you want to split left most side Values
First Duplicate the Column then split the column two times by Left most Delimiter
Now you can merge the two splitted Colums.You can get it now
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.