Previous value

[RicardoXavier]

Hello dear community, 

I am trying to get the previous value from a list, 

I would like to get the value 199.10, from the item name = ACAG-223UI, selectin the previous date from the last date. 

Thanks and regards, 

RG

[v-chenwuz-msft · Accepted solution]

Hi @RicardoXavier,

Maybe you can try this code:

previous of the last date =
VAR _lastdate =
    CALCULATE(
        MAX( 'table'[START DATETIME] ),
        ALLSELECTED( 'table'[START DATETIME] )
    )
RETURN
    MAXX(
        CALCULATETABLE(
            TOPN( 2, 'table', [START DATETIME], 0 ),
            FILTER(
                ALLEXCEPT( 'table', 'table'[OFM_NAME] ),
                [START DATETIME] < _lastdate
            )
        ),
        [OIL_VOL_RATE]
    )

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@RicardoXavier See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous