Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have been searching and trying out for hours. Really simple thing that I need and cannot figure why this is not working.
>>I want to have a DAX formula to have a new column - Person last salary change period. I want to use this column later for measures like average over organization etc.
>> This should be this but somehow this doesn't work
Solved! Go to Solution.
@krete-datadream does this work
Column =
CALCULATE (
CALCULATE (
MAX ( 'Table'[period] ),
FILTER (
ALL ( 'Table' ),
'Table'[increase] <> 0
&& 'Table'[emp] = MAX ( 'Table'[emp] )
)
)
)
or
Column=
CALCULATE (
MAX ( 'Table'[period] ),
ALLEXCEPT ( 'Table', 'Table'[emp] ),
'Table'[increase] <> 0
)
tried the 2nd one and it worked! So simple it was.
@krete-datadream does this work
Column =
CALCULATE (
CALCULATE (
MAX ( 'Table'[period] ),
FILTER (
ALL ( 'Table' ),
'Table'[increase] <> 0
&& 'Table'[emp] = MAX ( 'Table'[emp] )
)
)
)
or
Column=
CALCULATE (
MAX ( 'Table'[period] ),
ALLEXCEPT ( 'Table', 'Table'[emp] ),
'Table'[increase] <> 0
)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.