The syntax for ',' is incorrect. (DAX(VAR Total_Hours = SUMX( Deployment, HOUR(Deployment[Time Spent

[Balwinder_micky]

Deployment time2 =

VAR Total_Hours =

    SUMX(

        Deployment,

        HOUR(Deployment[Time Spent]) + MINUTE(Deployment[Time Spent])/60 + SECOND(Deployment[Time Spent])/3600

        )

VAR DaysTotal = Total_Hours/24

VAR DaysInt = TRUNC(DaysTotal)

VAR HoursTotal = (DaysTotal - DaysInt)*24

VAR HoursInt = TRUNC(HoursTotal)

VAR MinutesTotal = (HoursTotal - HoursInt)*60

VAR MinutesInt = TRUNC(MinutesTotal)

VAR SecondsTotal = ROUND(MinutesTotal - MinutesInt)*60,0)

RETURN

    DaysInt&"d, "&FORMAT(HoursInt,"00")&"h, "&FORMAT(MinutesInt,"00")&"m, "&FORMAT(SecondsTotal,"00")&"s "

[amitchandak]

@Balwinder_micky , Problem with round

Deployment time2 =
VAR Total_Hours =
SUMX(
Deployment,
HOUR(Deployment[Time Spent]) + MINUTE(Deployment[Time Spent])/60 + SECOND(Deployment[Time Spent])/3600
)
VAR DaysTotal = Total_Hours/24
VAR DaysInt = TRUNC(DaysTotal)
VAR HoursTotal = (DaysTotal - DaysInt)*24
VAR HoursInt = TRUNC(HoursTotal)
VAR MinutesTotal = (HoursTotal - HoursInt)*60
VAR MinutesInt = TRUNC(MinutesTotal)
VAR SecondsTotal = ROUND((MinutesTotal - MinutesInt)*60,0)
RETURN
DaysInt&"d, "&FORMAT(HoursInt,"00")&"h, "&FORMAT(MinutesInt,"00")&"m, "&FORMAT(SecondsTotal,"00")&"s "

[Balwinder_micky]

Dear @amitchandak , I am so sorry, I am not able to understand, could you please highlight or change the values and share them with me?

I really appriciate your help.