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

2 Replies

  • 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 🙂