Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating Consumption from day before

Hi,  I have a data set gathering readings from various meters per mintue in a table called historian, the readings are accumlated, i am trying to get the daily consumption by getting the difference ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    I have managed to find a work around whenever the meter gets reset, by having an If condition and adding the maximum reading number to the last value and subtracting the next day reading. 

     

    Thanks 

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Use the following pattern to extract the latest reading in a day,

Latest Reading =
MAXX( TOPN( 1, Historian, Historian[DateTime] ), Historian[Reading] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, Thank you for your response 

     

    but your formula will get the latest reading or max per the day which accumlated from the day before, i need to have the difference between day 2 and day 1.  I need only the consumption happened on the day. 

     

    Thanks