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
camargos88
Community Champion
Community ChampionHi 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
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