Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Hope you can help me with this issue.
I'm Splitting a column by delimiter and it looks like this:
#"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column1", "xxx", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"xxx1", "xxx2"}),
As you can see, I use "-" to split the text.
But I need to make an exception on it.
If it recognizes "- SpecificWord" so don't split it.
Any idea how I can make it work?
Thank you!
Solved! Go to Solution.
Hi,
Try using the below DAX to create the calculated column.
Here Data[Name] is the field which is to be split.
Hi,
Try using the below DAX to create the calculated column.
Here Data[Name] is the field which is to be split.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |