Creating a Measure with min and max of a datetime groupped by day

[KamEt69]

Hello,

I need to create a quite complicated measure.

It is like a login time and it is calculated ad follows.

in my table I have eventtime and I need to subtract the max and the min.

I acheaved this by simply creating a metric maxT and minT and subtracting them.

This works perfectly if I select just one day in my dashboard, but obviusly it does't if I select more than one day because it will include also the night.

What I would like to do is for this metric to calculate the sum of the logged time but calculated day by day.

So when is caluculated minT and maxT it should be grouped by day and agent, then subtracted to calculate the logintime for that day and then summed for more than one day or more that one agent if I so select.

Sorry for the poor description but since it's quite complicated I dont know how to explain it better.

[jdbuchanan71 · Accepted solution]

@KamEt69 

It sounds like you need to look at SUMX over your 'Calendar'[Date] column.  It would look something like this.

Total Login Time = 
SUMX ( 'Calendar'[Date], [Your Measure] )

[Your Measure] is the one you already have that is working when you look at a single day.  This new measure will iterate it over the list of dates then add up the individual results.

[KamEt69]

It worked, thank you!