Forum Discussion

Frequent Visitor

6 years ago

Solved

Max Date by Condiction

Dear, I have the following situation: Raw Data Column 1 Column 2 Column 3 ID 1 Task 1 Due Date A ID 1 ...

Icon for Community Champion rank

Community Champion

6 years ago

Hi LD ,

Try this measure:

Measure = CALCULATE(MAX('Table'[Column 3]); ALLEXCEPT('Table'; 'Table'[Column 1]))

If you consider it as a solution, please mark as a solution and kudos.

Ricardo

Frequent Visitor

6 years ago

Dear camargos88 ,

Command is quite ok..., Please, I need to exclude some row based on the Column2 (for example Task2 in Cl2)

Thank You

LD

camargos88
Community Champion
6 years ago
LD ,

I didn't get what you want.

Can you explain more ?

Ricardo
- LD
  Frequent Visitor
  6 years ago
  Yes, I'm sorry...
  
  For example, I need to exclude (in ID3) the Due Date E because coming from Task3...
  so all Task3 in every ID(1,2,3, n) will be not selected to determinate the max Due Date.
  
  In the Example, the Due date should be "Due Date D"
  
  I hope I was clear 🙂
  
  Thank you!!!!
  
  LD
  - camargos88
    Community Champion
    6 years ago
    LD ,
    
    Can you post the expected result ?
    
    Ricardo