Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarized columns value

I have a column timespent_inSeconds. Which is a Text field with a value. I have created a column Minuten (minutes) with the following Query: Minuten = VAR TimeSecs = ( IncidentTimeRegistrations[tim...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I found the solution:

     

    i created a new column and put in the following dax formula:

     

    Time = FORMAT((IncidentTimeRegistrations[timeSpent_inSeconds]/3600)/24; "HH:mm:ss")
     
    pointing to the timespent which is formatted as a number. This new Time Column is formatted as a time column in the notation HH:mm:ss
     
    After that i create a new measure based on this column with the following DAX formula:
     
    Meting = SUM(IncidentTimeRegistrations[Time])
     
    i formatted this measure as date/time with notation HH:mm. I don't need the seconds.