Forum Discussion

Bessonnizza1992's avatar
Bessonnizza1992
Helper I
5 years ago

pull values ​​down

Hello all!   How to pull values ​​down, need measure, not PQ.    
Need Help
Bessonnizza1992's avatar
Bessonnizza1992
Helper I
5 years ago

Ty for reply, sanalytics 

 

Tried yours measure, but power bi froz and couldn't load so much data. CalendarTime table have 86400 rows. I have an idea with another measure:

 

_DiscreteSensor / PreviousValue = 
VAR _1 =
    MAX ( 'CalendarTime'[Index] ) - 1
RETURN
    CALCULATE (
        MAX ( StatisticsDiscreteSensors[Value] ),
        FILTER ( ALL ( 'CalendarTime' ), CalendarTime[Index] = _1)
    )

 

All is ok, but measure return return values in incorrect time row. For example:

 

Timestamp - value - previous value

05:53:40 - blank - 0 / timestamp must be 07:00:03

07:00:04 - 0 - blank

07:00:05 - blank - 0 / timestamp must be 08:02:58

08:02:59 - 0 - blank

 

 

Do you know how can i do it?

sanalytics's avatar
sanalytics
Super User
5 years ago

@Bessonnizza1992,
can you please provide us some dummy data and your exact output so that, we can try..it is very difficult to assume your exact requirement by a screenshot.

Regards

sanalytics