Forum Discussion
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 Task 2 Due Date B
ID 2 Task 1 Due Date C
ID 3 Task 1 Due Date D
ID 3 Task 2 Due Date D
ID 3 Task 3 Due Date E
ID n ...... ......
I need to select the due max due date, excluding the task 2 and considering the Column 1.
The result is the association of Max due date to ID (1,2,3, n) excluding some condiction (by Column 2).
Thank you!!!!
LD
Hi camargos88 ,
Yes:
Column1 Column2 Due Date Measure ID1 Task Type A Jan 31, 20 March 31, 20 ID1 Task type B Mar 31, 20 March 31, 20 ID2 Task Type A Aug 22,20 Aug 22,20 ID3 Task Type A Apr 18, 20 Apr 18, 20 ID3 Task Type C Jun 20, 20 Apr 18, 20 ID4 Task Type A Apr 18, 20 May 05,20 ID4 Task Type B
May 05,20 May 05,20 ID4 Task Type C Jun 15, 20 May 05,20 so the task type C, is not considered into max value
Thank you
LD
LD ,
Try this measure:
Measure = CALCULATE(MAX('Table'[Due Date]); FILTER(ALLEXCEPT('Table'; 'Table'[Column1]); 'Table'[Column2] <> "Task Type C"))Ricardo
7 Replies
camargos88Community Champion
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
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