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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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
)
User | Count |
---|---|
9 | |
8 | |
5 | |
4 | |
3 |