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
sanalytics's avatar
sanalytics
Super User
5 years ago

Bessonnizza1992 ,
Please try below formula,
Min value =

SUM('Table'[Min of value])
 
Filldown= 
VAR _1= MAX('Table'[Time])
RETURN
CALCULATE([Min value],TOPN(1,FILTER(ALL('Table'),'Table'[Time] <=_1 && NOT(ISBLANK([Min value]))),'Table'[Time],DESC))

Hope,it will works..
 
regards,
sanalytics
  • 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