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
1n123/07/2022X
1n122/07/2022Submitted
1n121/07/2022Registered
2n223/07/2022X
2n221/07/2022Submitted
2n220/07/2022Registered
3n318/07/2022Registered

What I need to get is the date the user's status became "Submitted" and blank if they have not made it that far yet. 

The result should look something similar to this:

CandidateRef      Name     Date   Value   Submitted Date
1n123/07/2022X22/07/2022
1n122/07/2022Submitted22/07/2022
1n121/07/2022Registered22/07/2022
2n223/07/2022X21/07/2022
2n221/07/2022Submitted21/07/2022
2n220/07/2022Registered21/07/2022
3n318/07/2022Registered 

 

This seems so easy in theory and on paper but I just can't seem to get it in DAX!

I'm beginner in Power Bi and any help would be very appreciated!

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"
)

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    You can create a measure like

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