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
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.