Return column result from a search text string

[Anonymous]

New to Powerbi and lots of really useful contact in previous posts.

I would usually use LOOKUPVALUE to search for a booking ID in a separate table and return the created time. This time though the table where I am searching has multiple lines for the same BookingID. I am looking for the created time only for the line when it has a particular text string within the description column as in row2 (....Internal system). 

Thanks in advance

[DataInsights · Accepted solution]

@Shall871,

Try this calculated column:

Created Date = 
VAR vBookingID = BookingMain[Booking ID]
VAR vBookingDetails =
    FILTER (
        BookingDetail,
        BookingDetail[Booking ID] = vBookingID
            && CONTAINSSTRING ( BookingDetail[Description], "Internal System" )
    )
VAR vResult =
    MAXX ( vBookingDetails, BookingDetail[Created Date] )
RETURN
    vResult

[Anonymous]

Perfect thanks