how to get different value between hour

[rohazi]

please help how to get diff value for hour by hour. 

[FreemanZ · Accepted solution]

hi @rohazi 

try to add a column like this:

Diff2 = 
VAR _time = [Time]
VAR _date = [Date]
VAR _table =
FILTER(TableName, TableName[Date] = _date)
VAR _maxtime =
MINX(
    FILTER(
       _table,
        TableName[Time] > _time
    ),
    TableName[Time]
)
VAR _totalpre=
MAXX(
    FILTER(
       _table,
        TableName[Time] =_maxtime
    ),
    TableName[total]
)
RETURN
[Total] - _totalpre

it worked like this:

[rohazi]

tq @FreemanZ  . it's working ..thanks for your help.

[rohazi]

69706 -58277

[rohazi]

60706 - 58277

[FreemanZ]

hi @rohazi 

58277 - 69706?

[rohazi]

yes