Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi i have a calculated value i.e 1:2356 i want to show only right value of ":".
Solved! Go to Solution.
Use any of the following where Data is the column name
= Text.AfterDelimiter([Data],":")
= Text.Split([Data],":"){1}
Use any of the following where Data is the column name
= Text.AfterDelimiter([Data],":")
= Text.Split([Data],":"){1}
| User | Count |
|---|---|
| 11 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |