Calculating a column based on 2 different rows with equal unit serial and different cells

WAB_Reports any here is the DAX for a new column, tweak it as you see fit

New Combine = 
IF ( 'Table'[Service Type] = "B", "N/A",
    VAR __daysTypeA = 
    CALCULATE ( 
        SUM ( 'Table'[Difference in Days From Today] ), 
        ALLEXCEPT ( 'Table', 'Table'[UNIT Serial] ),
        'Table'[Service Type] = "A" 
    )
    VAR __monthsypeB = 
    CALCULATE ( 
        SUM ( 'Table'[Difference in Months from Today's Month] ), 
        ALLEXCEPT ( 'Table', 'Table'[UNIT Serial] ),
        'Table'[Service Type] = "B" 
    )
    RETURN
    IF ( __daysTypeA <= 14 && __monthsypeB >= 0 && __monthsypeB <= 4, "Yes", "No" )
)

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡