Forum Discussion
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 ...
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
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
camargos88
Community Champion
Community ChampionLD ,
Try this measure:
Measure = CALCULATE(MAX('Table'[Due Date]); FILTER(ALLEXCEPT('Table'; 'Table'[Column1]); 'Table'[Column2] <> "Task Type C"))
Ricardo