Forum Discussion

New Member

4 years ago

Solved

Split values

Hi i have a calculated value i.e 1:2356 i want to show only right value of ":".

Vijay_A_Verma
4 years ago
Use any of the following where Data is the column name
= Text.AfterDelimiter([Data],":") = Text.Split([Data],":"){1}

Most Valuable Professional

4 years ago

Use any of the following where Data is the column name

= Text.AfterDelimiter([Data],":")

= Text.Split([Data],":"){1}