Convert to string ( 10 days, 2 hours, 1 minute for example ) to only minutes

[ronniealfaro]

Hello all,

So my data source is giving a duration in the form of

4 hours 5 minutes

1 day 2 hours 1 minute

56 minutes

I was wondering how this could be transformed into a minutes only result, since i can have days, hours or minutes, I guess it can be done with Dax.

No, the data source can't be changed, at least not in time for some dashboards we need out.

Any idea on how to make this work??

Thanks in advance.

[v-yulgu-msft · Accepted solution]

Hi @ronniealfaro,

You can achieve this via Power Query. Please add custom columns in Query Editor mode.

=if Text.PositionOf([Column1],"day") <0 then 0 else Number.FromText(Text.Start([Column1], Text.PositionOf([Column1],"day")))

=if Text.PositionOf([Column1],"hours") <0 then 0 else Number.FromText(Text.End(Text.Trim(Text.Start([Column1], Text.PositionOf([Column1],"hours"))),2))

=if Text.PositionOf([Column1],"minutes")<0 then 0 else Number.FromText(Text.End(Text.Trim(Text.Start([Column1], Text.PositionOf([Column1],"minutes"))),2))

=[day value]*24*60+[hour value]*60+[minute value]

Best regards,

Yuliana Gu

[ronniealfaro]

Thank you @v-yulgu-msft

It did the job