Forum Discussion
karimkz
9 years agoAdvocate I
DAX reference to current row value??
Hello! I can't find a solution for this lilttle problem. Here is the dataset, it has Units and Performance. I want to make a calculated column with a Maximum Performance for each distinct Unit. (...
- 9 years ago
Hi karimkz,
if you are using calculated column:
maximum = CALCULATE(MAX(table[performance]),filter(all(table), table[unit] = earlier(table[unit]) ) ))
(earlier/earliest will return current row in calculated column expression)
tringuyenminh92
9 years agoMemorable Member
Hi karimkz,
if you are using calculated column:
maximum = CALCULATE(MAX(table[performance]),filter(all(table), table[unit] = earlier(table[unit]) ) ))
(earlier/earliest will return current row in calculated column expression)