Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous Value by Device & Time

Hello Everybody, i've spent the whole afternoon with this dataset:   mts DeviceID cOut 19/10/2020 00:00 A 16.4 19/10/2020 00:05 A 16.4 19/10/2020 00:10 A 16.4 19/10/2020 00:...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , not sure how got this avg of 20,

     

    Try a new column

    calculate(lastnonblankvalue([mtsHour],max(Average of cOut)),filter(table, [Device] = earlier([Device]) && [mtsHour] <earlier([mtsHour])))

     

    or new measure

    calculate(lastnonblankvalue([mtsHour],max(Average of cOut)),filter(allselected(table), [Device] = max([Device]) && [mtsHour] <max([mtsHour])))

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 
Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

 

Best Regards,
Community Support Team _ Eason