Forum Discussion

rohazi's avatar
rohazi
Frequent Visitor
3 years ago
Solved

how to get different value between hour

please help how to get diff value for hour by hour.     
  • FreemanZ's avatar
    3 years ago

    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: