Forum Discussion

karimkz's avatar
karimkz
Advocate I
9 years ago
Solved

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. (...
Need Help
Tips and Tricks
Tutorial Requests
  • tringuyenminh92's avatar
    tringuyenminh92
    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)

Spurta's avatar
Spurta
Frequent Visitor
8 years ago

Did you ever figure out how to incorporate this into a Measure? I'm struggling with something similar.

markus_zhang's avatar
markus_zhang
Advocate III
7 years ago

Hopefully you guys figured this out, amazing how difficult to get this simple stuff done in the context of Power Pivot. I really think they should blend the functionalities of Excel and Power Pivot all together. There are things that can be done in 5 seconds in Excel, but would take 5 days to learn to how to get in PP, and vice versa.