topic Re: EARLIER function dax in DAX Commands and Tips

EARLIER function dax

bjurek — Thu, 23 Mar 2023 14:27:49 GMT

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.

Re: EARLIER function dax

tamerj1 — Thu, 23 Mar 2023 16:06:06 GMT

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

Re: EARLIER function dax

Anonymous — Mon, 27 Mar 2023 06:06:22 GMT

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