Format function does not support for direct query

Hi Shree_185 ,

Format function is not supported in Direct Query mode in Power BI. You need to convert your connection mode to import to use it.

Or I suggest you to create two calcualted columns, one to show Days and another one to show times in time type formated as hh:mm:ss. 

Pending Customer in Days = 
VAR dayNo =
    INT ( [BMCServiceDesk__TimeSpentInCurrentStatus__c] / 1440 )
RETURN
    dayNo & " day "

Pending Customer in Times = 
VAR hourNo =
    INT ( MOD ( [BMCServiceDesk__TimeSpentInCurrentStatus__c], 1440 ) / 60 )
VAR minuteNO =
    MOD ( MOD ( [BMCServiceDesk__TimeSpentInCurrentStatus__c], 1440 ), 60 )
VAR secondNo =
    INT (
        (
            [BMCServiceDesk__TimeSpentInCurrentStatus__c]
                - INT ( [BMCServiceDesk__TimeSpentInCurrentStatus__c] )
        ) * 60
    )
RETURN
TIME(hourNo,minuteNO,secondNo)

Result is as below.

Best Regards,
Rico Zhou

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