Solved: EARLIER function dax

bjurek · ‎03-23-2023

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 · ‎03-26-2023

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

View solution in original post

Anonymous · ‎03-26-2023

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

tamerj1 · ‎03-23-2023

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]
)