Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Create a Straight Table
Dimension
Project
Expressions
Max({<[Current State] = {1}>}[Finish Date])
FirstSortedValue(System, -Aggr(Max({<[Current State] = {1}>}[Finish Date]),Project,System))
rammuthiah is your question solved?