Forum Discussion

bjurek's avatar
bjurek
Helper I
3 years ago
Solved

EARLIER function dax

Hello!

 

Can someone help me write this correctly? It's about entering a value from an earlier date. I'm trying to do it using "EARLIER" but it doesn't work for me.

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  bjurek ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Calculated Column1 =
MAXX(
    FILTER(ALL('Table'),
    'Table'[Shop]=EARLIER('Table'[Shop])&&
    'Table'[Date]<EARLIER('Table'[Date])),[Date])

    2. Result:

     

    Best Regards,

    Liu Yang

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi bjurek 

    Please clarify further the part that says "skip product B". 

    Please try

    Previous Product =
    MAXX (
    TOPN (
    1,
    FILTER (
    CALCULATETABLE ( ALLEXCEPT ( 'Table', 'Table'[Shop] ) ),
    'Table'[Date] < EARLIER ( 'Table'[Date] )
    ),
    'Table'[Date]
    ),
    'Table'[Product]
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  bjurek ,

     

    Here are the steps you can follow：

    1. Create calculated column.

    Calculated Column1 =
MAXX(
    FILTER(ALL('Table'),
    'Table'[Shop]=EARLIER('Table'[Shop])&&
    'Table'[Date]<EARLIER('Table'[Date])),[Date])

    2. Result:

     

    Best Regards,

    Liu Yang

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