Forum Discussion

DreDre's avatar
DreDre
Icon for Helper II rankHelper II
5 years ago
Solved

Given arrival and depart datetime in the same row, chart data over multiple days

I am stuck on this one and have tried a couple methods from the forum, but maybe someone can help with this   I have a list of data that shows what time a car arrives at a facility and what time it...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi DreDre ,

    I'm so sorry that I made a mistake when update the measure: written the field [DepLoc DateTime] as [DepLoc] wrongly. That's why you can't get any value....

    Measure =
    CALCULATE (
    COUNT ( 'Sheet1'[Eqp] ),
    FILTER (
    ALL('Sheet1'),
    'Sheet1'[ArrInLoc] <= SELECTEDVALUE ( 'Date'[DateTime] )
    && 'Sheet1'[DepLoc DateTime] >= SELECTEDVALUE ( 'Date'[DateTime] )
    )
    )
     

    Best Regards

DreDre's avatar
DreDre
Icon for Helper II rankHelper II
5 years ago

Hello Anonymous, not sure if you made an additional adjustment to the file aside from the measure, but when I update the measure with what you have above I do not see any data. Is there something I am missing here?

Sorry for the delay in responding, I have been out of town, but I do not think this solves the problem quite yet.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi DreDre ,

I'm so sorry that I made a mistake when update the measure: written the field [DepLoc DateTime] as [DepLoc] wrongly. That's why you can't get any value....

Measure =
CALCULATE (
COUNT ( 'Sheet1'[Eqp] ),
FILTER (
ALL('Sheet1'),
'Sheet1'[ArrInLoc] <= SELECTEDVALUE ( 'Date'[DateTime] )
&& 'Sheet1'[DepLoc DateTime] >= SELECTEDVALUE ( 'Date'[DateTime] )
)
)
 

Best Regards