Forum Discussion
pull values down
Bessonnizza1992
I have seen your file..The Measure you have written will not return any value neither on 00:04:59 timestamp or on any other timestamp which has blank on previous timestamp.look at the 00:00:01, your previous time stamp 00:00:00 has 0 min value so therefor you will get the min value of 00:00:00 into the 00:00:01 time stamp.but you will get the blank value of 00:00:02,00:00:03 and so on.beacause,there are no min of value on previous time stamp like (00:00:01 or 00:00:02).
The measure i have provided will not allow you to execute beacuse of heavy row size in CalendarTime table.The idle section of doing this kind of stuff is Manipulation section..Why cant you use power query?It will take just 1 min to achieve this.Assume that, you are bound to write a measure.Then only, you can create a supporting table and after that you can pull out the value by dax and then you can hide this table from report view.see your file, what i have done.
https://dropmefiles.com/AhgMB
Hope you will get some help from this way.
I am tagging Greg_Deckler ..Hope he will guide you more efficiently.
Regards,
Sanalytics
sanalytics , ty for yours recomendations.
As an end result, this is what I need. But i can't use power query cause i get Statistics table from web service, its have over 2 bill rows and updated every day. In the example which I dropped only one sensor, in a real request 102 sensors, so i need to created support table in each sensor.
Hi Bessonnizza1992,
I can use the following measure formula to reproduce the chart as your snapshot displayed.
Measure = VAR currDate = MAX ( CalendarTime[Time] ) VAR prev = CALCULATE ( MAX ( Statistics[Timestamp] ), FILTER ( ALLSELECTED ( Statistics ), [Timestamp] <= currDate ) ) RETURN CALCULATE ( MAX ( Statistics[Value] ), FILTER ( ALLSELECTED ( Statistics ), [Timestamp] = prev ) )How did you really table structure like? Can you please share some dummy data with multiple sensors then we can test to coding formula on it?
How to Get Your Question Answered Quickly
Regards,Xiaoxin Sheng
Anonymous , ty for reply!
All is working fine, but a little bit slow.
Can you explain me how can i filtered this rows? Only the current line (with original value) and previous line needs to be left. The end result should look like:
