Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Changing decimal number into Duration

I have a table with a Start and Finish time I have created a calculated column which subtracts Finish time from start time to give me a duration. The issue I'm having is the format in which the Durat...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Is this problem sloved?
 
If it is sloved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
 
If not, please let me know.
 
Best Regards
Icey
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Icey, 

     

    This is still ongoing unfortunantly!  when I tired to use Gregs Dax code I'm getting a insuffient RAM message, My laptop has 32GB and Corei7 8th Gen Processor. 

     

    When I get the issues sorted I'll mark the soultion!

     

    Thanks 

    Dobby

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      Based on my knowledge, Power BI doesn't support to display Duration type in Power BI Report View as in Power Query.

      You can vote this idea to make it come soon. 

      If you must display the duration time in the report view, there is one workround. You can copy the column and set it to text format and place it on the Tooltip. You can refer to this post: Time Duration and Time Graph Plotting.

       

      Best Regards,
      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.