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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |