Forum Discussion

Maheshkaka's avatar
Maheshkaka
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 ":".

  • Use any of the following where Data is the column name

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

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    Use any of the following where Data is the column name

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