Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Translate MAXIFS from Excel into DAX

hi SuperUsers, I read a number of post regarding the solution to translate MAXIFS from Excel into DAX but I'm not able to make it work. Here is a sample of the table i have. I am trying to find ou...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    hi 

    Managed to finally solve the issue with this formula

    CALCULATE(MAX('[Month #]),FILTER('TableA','TableA'[Recognize Revenue]>0 && 'TableA'[Order-Line]=EARLIER('TableA'[Order-Line]))).
    Find this solution is easlier to apply and understand.
Anonymous's avatar
Anonymous
Not applicable
3 years ago

hi 

Managed to finally solve the issue with this formula

CALCULATE(MAX('[Month #]),FILTER('TableA','TableA'[Recognize Revenue]>0 && 'TableA'[Order-Line]=EARLIER('TableA'[Order-Line]))).
Find this solution is easlier to apply and understand.