Forum Discussion

qwertzuiop's avatar
qwertzuiop
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Calculate time interval to next message

Hello dear PowerBI-Community   I hope you guys could help me with the following problem. In the example (see table) there are several transports. Each transport has an unique ID.   A transport ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi qwertzuiop ,

     

    Measure = 
VAR temp_table =
    FILTER (
        SUMMARIZE (
            ALL ( 'Table'[transportID]; 'Table'[messageCreated] );
            'Table'[messageCreated];
            'Table'[transportID]
        );
        'Table'[messageCreated] > MAX ( 'Table'[messageCreated] )
            && 'Table'[transportID] = SELECTEDVALUE ( 'Table'[transportID] )
    )
VAR Current_Date =
    SELECTEDVALUE ( 'Table'[messageCreated] )
VAR Time_difference =
    DATEDIFF ( Current_Date; MINX( temp_table; 'Table'[messageCreated] ); MINUTE ) / 60 + 0
RETURN
    Time_difference
qwertzuiop's avatar
qwertzuiop
Icon for Advocate III rankAdvocate III
6 years ago

I don't know why but figure 2 was missing.

sorry

 

figrue 2

qwertzuiop's avatar
qwertzuiop
Icon for Advocate III rankAdvocate III
6 years ago

Excuse me

Now I got it.

The calculated table is the one out of my example.

But then why is this error?