'Power Query not able to transform time data

I was able to convert raw time file format 01.36.44 into 1:36:44 AM in the table view, but not in Power Query. That leaves me unable to derive duration from two time fields.

Two questions:

  1. Is there a way to transform the 00.00.00 format to time in Power Query? It seems strange that you could do it in the table view and not Power Query.
  2. If there is no way to format in Power Query, how can I create a measure to calculate duration in the Power BI table view? Duration here seems to be a totally different formula from DAX having to so with cash flow!?!

Power Query

Power BI table view

duration


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions