Forum Discussion

Ovidijus's avatar
Ovidijus
Frequent Visitor
3 years ago

Date time subtraction

Hello Pbix`ers,   Struglling with measure creation.   Have two subtract value lik ein picture?    
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Ovidijus , Try like

 

new measure =
var _max = maxx(filter(allselected(Table), Table[Meter Number] = max(Table[Meter Number]) && Table[Date] < max(Table[Date])), Table[Date] )
return
sum( Table[Value]) - sumx(filter(allselected(Table), Table[Meter Number] = max(Table[Meter Number]) && Table[Date] = _max), Table[Value] )

 

 

or

 

new measure =
var _max = maxx(filter(allselected(Table), Table[Meter Number] = max(Table[Meter Number]) && Table[Date] < max(Table[Date])), Table[Date] )
return
sum( Table[Value]) - sumx(filter((Table), Table[Date] = _max), Table[Value] )

Ovidijus's avatar
Ovidijus
Frequent Visitor
3 years ago

Hey, solution probably would work but i played a little yesterday and need this visual as in the top table.

 

Need to see calculated values from Meters minus 12 hours.

 

That would be massive help to solve 🙂