Finding out Previous Stock Created Date

[Anonymous]

my calender date slicer range is as given below :

StockDate : stockcreated date with in the selected calender date range.

PreviousStockDate : Previous Stockcreated Date with in the selected calender date range.

Plese help me to write the Measure for PreviousStockDate column. 

Thanks

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

maxx(filter(allselected(Table), Table[Stockdate] <Max(Table[StockDate])),Table[StockDate])

[Icey · Accepted solution]

Hi @Anonymous ,

These measures will give you the same result:

Measure =
CALCULATE (
    MAX ( 'Table'[StockDate] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Stockdate] < MAX ( 'Table'[StockDate] )
    )
)

Measure =
VAR CurrentNo_ =
    MAX ( 'Table'[Cust_No] )
VAR PreviousNo_ =
    CALCULATE ( MAX ( 'Table'[Cust_No] ), 'Table'[Cust_No] < CurrentNo_ )
RETURN
    CALCULATE ( MAX ( 'Table'[StockDate] ), 'Table'[Cust_No] = PreviousNo_ )

Best Regards,

Icey

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

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

maxx(filter(allselected(Table), Table[Stockdate] <Max(Table[StockDate])),Table[StockDate])