Parse time

datalogs1020 — Mon, 27 May 2019 08:19:11 GMT

Hi,

I need to create a new column minute and seconds based on the time lapse column.

I tried using the extract, but it doesn't seem to work in all cases . (ie, sometimes, it says "minute" or "minutes" or no minutes at all)

Can someone help me please? Newbie here.

Thank you!

Table1

Time lapse	minute	seconds
25 minutes, 10 seconds	25	10
1 minute	1
23 seconds	0	23

Re: Parse time

MauriceMecowe — Mon, 27 May 2019 09:35:06 GMT

Hi Datalogs1020,

It depends on the formate of your Time lapse column. If it's always the same structure, you can use a LEFT or RIGHT function to extract the correct value per column and use an ISBLANK for 0. If the format of Time Lapse differs per entry, I don't think this is possible

topic Parse time in DAX Commands and Tips

Parse time

Re: Parse time