Skip to main content

HI 


I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.

Hi Jyothi


Just so everybody who reads this question knows it is possible to solve.

The solution to this is, you set up the format as hh🇲🇲ss. You cant find it in the list, but manually typing it in will work.

Before you us this, you need to divide your measure with a fraction of a day. So Seconds is 86400 (60*60*24), minutes is 1440 (60*24) and hours is 24.

Hi Thomas,

It worked as expected. I'm glad that you gave me a solution.

Reply


Terms and ConditionsCookie settings