Hi, how to create column to extract text after delimiter.
Data:
8/12
2/1
3/4
Expected output:
12
1
4
Solved! Go to Solution.
@PBI_newuser , In power query
new column Text.AfterDelimiter([Column], "/")
https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter
in DAX
new column = right([Column], len([column]) - search("/",[Column],,0))
@PBI_newuser , In power query
new column Text.AfterDelimiter([Column], "/")
https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter
in DAX
new column = right([Column], len([column]) - search("/",[Column],,0))
User | Count |
---|---|
135 | |
63 | |
57 | |
56 | |
46 |
User | Count |
---|---|
139 | |
65 | |
61 | |
60 | |
53 |