STEP 1STE2STEP 3Hi Guys,
I have an interger value column from which I need to convert it to hh:mm format, Below is the example.
I have a column with values 9, 10.8,12...etc... Now I am trying to convert these values to hh:mm format by creating a measuer like sum(field)/24. it is dividing the value with 24 but I also need the format type to be hh:mm.
For example if I have a value of 310, 137.18 I have created a measuer xyz = sum(310, 137.18)/24 = 12,922.38 now I want to convert this 12,922.98 into hh:mm.
In excel I have done the same and righ clicked on the cell and choose format --> Number--> custom --> [h]:mm I get 310137:10.
I am strugllng to do the same in power bi as the data type function in modelling is disabled,If I highlight the measuer and click on the modeling the data type is not enabled.
Please find the screenshots below.Any suggestions please help, Let me know if needed any details Thanks