System Logic

[rammuthiah]

I want to show the system for the project # based on the logic given below

Output:

Project #, System, Date

1,              D,         6/2/2018

Project	System	Finish Date	Current State	Based on the logic, I want to show the system where current state is equal to 1 and based on maximum Finish Date
1	A	30/07/2017	1
1	B	23/09/2015	0
1	C	29/11/2015	0
1	D	6/2/2018	1
1	E	25/07/2017	0

[Thiago_Justen_]

I'm not sure if I got your point, but here it is:

FirstSortedValue(System,-Aggr(If([Current State]=1,[Finish Date]),[Finish Date]))

This expression will give you System's location as you want.

Cheers

[MK_QSL]

Create a Straight Table

Dimension

Project

Expressions

Max({<[Current State] = {1}>}[Finish Date])

FirstSortedValue(System, -Aggr(Max({<[Current State] = {1}>}[Finish Date]),Project,System))

[Thiago_Justen_]

rammuthiah is your question solved?