Calculate duration from String in Dax

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,makarama .I am glad to help you.
Like this?
Using IFERROR() allows the entire judgment logic to be more streamlined

ResultsDuration = 
VAR FullText = 'Table02'[Duration]
-- theDayNum
VAR PositionDays = SEARCH(" Days", FullText, 1, LEN(FullText) + 1)
VAR PositionDay = SEARCH(" Day", FullText, 1, LEN(FullText) + 1)
VAR PositionDayResult = IF(PositionDays <> LEN(FullText) + 1, PositionDays, PositionDay)
VAR Days = IF(PositionDayResult <> LEN(FullText) + 1, VALUE(RIGHT(LEFT(FullText, PositionDayResult - 1), 2)), 0)
-- theHourNum
VAR PositionHours = SEARCH(" Hours", FullText, 1, LEN(FullText) + 1)
VAR PositionHour = SEARCH(" Hour", FullText, 1, LEN(FullText) + 1)
VAR PositionHourResult = IF(PositionHours <> LEN(FullText) + 1, PositionHours, PositionHour)
VAR Hours = IF(PositionHourResult <> LEN(FullText) + 1, VALUE(RIGHT(LEFT(FullText, PositionHourResult - 1), 2)), 0)
-- theMinuteNum
VAR PositionMinutes = SEARCH(" Minutes", FullText, 1, LEN(FullText) + 1)
VAR PositionMinute = SEARCH(" Minute", FullText, 1, LEN(FullText) + 1)
VAR PositionMinuteResult = IF(PositionMinutes <> LEN(FullText) + 1, PositionMinutes, PositionMinute)
VAR Minutes = IF(PositionMinuteResult <> LEN(FullText) + 1, VALUE(RIGHT(LEFT(FullText, PositionMinuteResult - 1), 2)), 0)
-- theSecondNum
VAR PositionSeconds = SEARCH(" Seconds", FullText, 1, LEN(FullText) + 1)
VAR PositionSecond = SEARCH(" Second", FullText, 1, LEN(FullText) + 1)
VAR PositionSecondResult = IF(PositionSeconds <> LEN(FullText) + 1, PositionSeconds, PositionSecond)
VAR Seconds = IF(PositionSecondResult <> LEN(FullText) + 1, VALUE(RIGHT(LEFT(FullText, PositionSecondResult - 1), 2)), 0)
RETURN (Days * 86400 + Hours * 3600 + Minutes * 60 + Seconds) / 3600

You can also use the CONTAINSSTRING() function
The function does the following
Get whether the target field exists or not from the text type data

The logic of the calculated column I created is as follows
Find the location of “ Hours” and “ Hour” in FullText.

Use the first position found (preferably “ Hours”).

Intercept the string and extract the last two characters.

Use the IFERROR function to handle potential error cases, ensuring that the default value of “0” is returned if “Hours” or “Hour” is not found.

This is actually the optimized version, but if you want to see the calculation more visually, you can refer to this calculation column

DurationInHours = 
VAR FullText = 'Table02'[Duration]
VAR Hours = IFERROR(
    VALUE(LEFT(FullText, SEARCH(" Hours", FullText, 1, LEN(FullText) + 1) - 1)),
    IFERROR(
        VALUE(LEFT(FullText, SEARCH(" Hour", FullText, 1, LEN(FullText) + 1) - 1)),
        0
    )
)
VAR result = 
    VAR positionHours = SEARCH(" Hours", FullText, 1, LEN(FullText) + 1)
    VAR positionHour = SEARCH(" Hour", FullText, 1, LEN(FullText) + 1)
    VAR position = IF(positionHours <> LEN(FullText) + 1, positionHours, positionHour)
    RETURN RIGHT(IFERROR(LEFT(FullText, position - 1), "error"), 2)
RETURN IFERROR(VALUE(result), 0)

I provided the test pbix, hope it helps.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.