Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Arul
Super User
Super User

DAX

What is earlier in DAX language?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

consider this data

Label Value
A 1
A 2
B 3
B 4
C 4
C 5

and then compare this calculated columns

Column1 = CALCULATE(SUM('Table'[Value]),ALL('Table'), 'Table'[Label]='Table'[Label])

Column2 = 
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table'), 
    'Table'[Label]=EARLIER('Table'[Label]) --we iterate over Table[Label] comparing it over the evalulation of the column in the filter context outside of CALCULATE
)

Column3 =
VAR CurrentLabel = 'Table'[Label] -- evaluated in the unmodified row specific context
RETURN
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table'), --changes filter context to the whole table
    'Table'[Label]= CurrentLabel 
)

 

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

3 REPLIES 3
Stachu
Community Champion
Community Champion

you can use it to change the filter context of a column to one of its previous states
https://dax.guide/earlier/

https://docs.microsoft.com/en-us/dax/earlier-function-dax

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Can you please explain me with a real time example?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Stachu
Community Champion
Community Champion

consider this data

Label Value
A 1
A 2
B 3
B 4
C 4
C 5

and then compare this calculated columns

Column1 = CALCULATE(SUM('Table'[Value]),ALL('Table'), 'Table'[Label]='Table'[Label])

Column2 = 
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table'), 
    'Table'[Label]=EARLIER('Table'[Label]) --we iterate over Table[Label] comparing it over the evalulation of the column in the filter context outside of CALCULATE
)

Column3 =
VAR CurrentLabel = 'Table'[Label] -- evaluated in the unmodified row specific context
RETURN
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table'), --changes filter context to the whole table
    'Table'[Label]= CurrentLabel 
)

 

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.