Forum Discussion

AntBI26's avatar
AntBI26
Frequent Visitor
1 year ago
Solved

Error fetching data for the visual

Hello all,    I have a visual card that shows the overall time of some activities. The time is calculated by adding the sum of time from two different table for Time Activities and Time Activities2...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi AntBI26 ,

     

    You can modify the formula you provided at the beginning by replacing the hours minutes and seconds directly with the split down fields:

    TotalTimeFormatted1 = 
//VAR TimeString1 = [TimeActivities]
VAR Hours1 = MAX('YourTable'[TimeActivities - Copy.1])
VAR Minutes1 = MAX('YourTable'[TimeActivities - Copy.2])
VAR Seconds1 = MAX('YourTable'[TimeActivities - Copy.3])
VAR TotalSeconds1 = (Hours1 * 3600) + (Minutes1 * 60) + Seconds1

//VAR TimeString2 = [TimeActivities2]
VAR Hours2 = MAX('YourTable2'[TimeActivities - Copy.1])
VAR Minutes2 = MAX('YourTable2'[TimeActivities - Copy.2])
VAR Seconds2 = MAX('YourTable2'[TimeActivities - Copy.3])
VAR TotalSeconds2 = (Hours2 * 3600) + (Minutes2 * 60) + Seconds2

VAR TotalSeconds = TotalSeconds1 + TotalSeconds2
VAR Hours = TRUNC(TotalSeconds / 3600)
VAR Minutes = TRUNC(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN
FORMAT(Hours, "00") & ":" &
FORMAT(Minutes, "00") & ":" &
FORMAT(Seconds, "00")

     

    Best Regards,
    Zhu

     

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

AntBI26's avatar
AntBI26
Frequent Visitor
1 year ago

Hello Zhu, thanks for your response. 

 

After following your method, I now receive this error message:

 

the measure concerns with the error are: 

TimeActivities =

VAR TotalSeconds=SUMX('Planner files for processing',HOUR('Planner files for processing'[Time.1])*3600+MINUTE('Planner files for processing'[Time.2])*60+SECOND('Planner files for processing'[Time.3]))
VAR Days =TRUNC(TotalSeconds/3600/24)
VAR Hors = TRUNC((TotalSeconds-Days*3600*24)/3600)
VAR Mins =TRUNC(MOD(TotalSeconds,3600)/60)
VAR Secs = MOD(TotalSeconds,60)
return IF((Hors + (Days*24))<10,"0"&(Hors + (Days*24)),(Hors + (Days*24)))&":"&IF(Mins<10,"0"&Mins,Mins)&":"&IF(Secs<10,"0"&Secs,Secs)
 
I am not sure where I am going wrong. 
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AntBI26 ,

     

    You can modify the formula you provided at the beginning by replacing the hours minutes and seconds directly with the split down fields:

    TotalTimeFormatted1 = 
//VAR TimeString1 = [TimeActivities]
VAR Hours1 = MAX('YourTable'[TimeActivities - Copy.1])
VAR Minutes1 = MAX('YourTable'[TimeActivities - Copy.2])
VAR Seconds1 = MAX('YourTable'[TimeActivities - Copy.3])
VAR TotalSeconds1 = (Hours1 * 3600) + (Minutes1 * 60) + Seconds1

//VAR TimeString2 = [TimeActivities2]
VAR Hours2 = MAX('YourTable2'[TimeActivities - Copy.1])
VAR Minutes2 = MAX('YourTable2'[TimeActivities - Copy.2])
VAR Seconds2 = MAX('YourTable2'[TimeActivities - Copy.3])
VAR TotalSeconds2 = (Hours2 * 3600) + (Minutes2 * 60) + Seconds2

VAR TotalSeconds = TotalSeconds1 + TotalSeconds2
VAR Hours = TRUNC(TotalSeconds / 3600)
VAR Minutes = TRUNC(MOD(TotalSeconds, 3600) / 60)
VAR Seconds = MOD(TotalSeconds, 60)
RETURN
FORMAT(Hours, "00") & ":" &
FORMAT(Minutes, "00") & ":" &
FORMAT(Seconds, "00")

     

    Best Regards,
    Zhu

     

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