Power Pivot (Calculated Column) : Convert number to dd:hh:mm format RRS feed

  • Question

  • Hi,

    I have created a Data Model from which I have created a perspective. The data model contains a column called as ResponseTime and ResolutionTime which contains number values (minutes). I am trying the create a calculated column called as ResponseDT and ResolutionDT respectively.

    Response Resolution

    I am able to create a calculated column in a normal table (ResponseTime/1440) and format it to Time value (dd:hh:mm). How can I do the same in Power Pivot, perspective?

    Thanks, Rajiv Iyer

    Wednesday, September 11, 2019 5:45 AM


All replies