Forum Discussion

Anonymous55's avatar
Anonymous55
Frequent Visitor
2 years ago
Solved

Struggling to split column or extract data - zero values

Hi!   I have an Excel spreadsheet which contains a list of phone calls received, and the durations of those calls. The durations are displayed as HH:MM:SS, for example:   00:00:21 00:00:13 00:0...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    Anonymous55 ,

    In Power Query:

    Text.End( [Duration],5 )  -- Replace [Duration] with the name of your column

    In DAX

    NewColumn = RIGHT( [Duration], 5 )
Anonymous55's avatar
Anonymous55
Frequent Visitor
2 years ago

Thank you so, so much for your help rsbin and apologies for my late reply! I have just tried your solution and it's worked perfectly. Thank you again for your help, I would never have figured this out on my own 🙂