Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |