Forum Discussion
Sum up connection time
Hi adamsli ,
We have checked your file. The issue is the Auto Date function.
You can close the Auto Date/Time function to solve this issue.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi adamsli ,
We assume that you already get the difference between connection and disconnection.
So we can create two measures to meet your requirement.
Duration =
VAR TotalSeconds=SUMX('Table',HOUR('Table'[Subtraction])*3600+MINUTE('Table'[Subtraction])*60+SECOND('Table'[Subtraction]))
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(DAYS=0,"",IF(DAYS>1,DAYS&"days",Days&"day"))&IF(Hors<10,"0"&Hors,Hors)&":"&IF(Mins<10,"0"&Mins,Mins)&":"&IF(Secs<10,"0"&Secs,Secs)
Connection count =
COUNT('Table'[M])
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Count works perfectly:
but I have problem with Duration:
Don't know why but I have zeros and becuase of this formula table shows data from 2015 to 2020 when I want in the filter only 2020.
Like I did in the slicer:
