Forum Discussion

JackData's avatar
JackData
New Member
4 years ago
Solved

Date determined by Value

Hi,  Need a bit of help getting this to work. This is what I have currently: CandidateRef     Name      Date   Value 1 n1 23/07/2022 X 1 n1 22/07/2022 Submitted 1 n1 21/07/20...
Need Help
Tutorial Requests
  • johnt75's avatar
    johnt75
    4 years ago

    You can create a measure like

    Submitted date =
CALCULATE (
    MIN ( 'Table'[Date] ),
    ALLEXCEPT ( 'Table', 'Table'[Candidate Ref] ),
    'Table'[Value] = "Submitted"
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You can create a measure like

Submitted date =
CALCULATE (
    MIN ( 'Table'[Date] ),
    ALLEXCEPT ( 'Table', 'Table'[Candidate Ref] ),
    'Table'[Value] = "Submitted"
)