The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |