calculate the number of hours between the rows

[Gianluigi]

Hello,

Hello
How can I calculate the number of hours between the rows in the following table?

Example between the second line and the first should be about 48 hours.

Thank you 

[v-yiruan-msft · Accepted solution]

Hi @Gianluigi ,

You can create a calculated column as below to get it, please find the details in the attachment.

Column = 
VAR _predatetime =
    CALCULATE (
        MAX ( 'Table'[dataEvento] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[dataEvento] < EARLIER ( 'Table'[dataEvento] )
        )
    )
RETURN
    DATEDIFF ( _predatetime, 'Table'[dataEvento], HOUR )

In addition, you can also create a measure as below to get it.

Number of hours between the rows = 
VAR _datetime =
    SELECTEDVALUE ( 'Table'[dataEvento] )
VAR _predatetime =
    CALCULATE (
        MAX ( 'Table'[dataEvento] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[dataEvento] < _datetime )
    )
RETURN
    DATEDIFF ( _predatetime, _datetime, HOUR )

Best Regards

[Gianluigi]

And then this mistake too

Error Message:
The template does not include a table named Column in the eventi table

[Gianluigi]

Hello
FYI, the new column doesn't work. Just save after a few minutes power bi reports this error

Error Message:
There is not enough memory to complete this operation. Please try again later when there may be more memory available.

[Gianluigi]

Great!

 Thank you very much!

[Jonvoge]

Hi Gianluigi.

If you update to the latest version of Power BI, you can try out the brand new Visual Calculation feature to calculate row-by-row: Exploring Power BI Visual Calculations – Data – Marc (data-marc.com).

If you use the DATEDIFF() DAX function together with a Visual Calculation, you should be able to achieve what you want.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.

[Gianluigi]

Thank you !

[Arul]

@Gianluigi ,

In which visual, Do you want this?

[Gianluigi]

In the table.