Forum Discussion

Arul's avatar
Arul
Super User
7 years ago
Solved

DAX

What is earlier in DAX language?
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    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 
)

     

     

Arul's avatar
Arul
Super User
7 years ago

Can you please explain me with a real time example?

Stachu's avatar
Stachu
Community Champion
7 years ago

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 
)