Forum Discussion
rohazi
3 years agoFrequent Visitor
how to get different value between hour
please help how to get diff value for hour by hour.
- 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] - _totalpreit worked like this:
rohazi
3 years agoFrequent Visitor
69706 -58277