Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Average of Measure

Hi all.   First or all, let me tell you that I went through several posts with similar questions but I couldn't solve the issue anyway. So I am seeking for help here. And I am coming back to PowerB...
Need Help
Show and Tell
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may try a similar way as shown here.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Some improvising?

 

I'm trying :smileyvery-happy:

 

TripLengthHours = DATEDIFF(
CALCULATE(MIN(Trips[Value]),Trips[Attribute]="TripStartTime"),
CALCULATE(MAX(Trips[Value]),Trips[Attribute]="TripEndTime"),
SECOND)/3600

 

Same problem, of course.