Add calculated column based on the matching values in other columns

Hey shiggs8 ,

yes, that's possible.

You can first check for the maximum number for the same Store, Order, etc.

If this number is > 0 then you can return "Bad Debt" and otherwise the Trans Type. Try the following calculated column:

Trans Type Calc NEW =
VAR vBadDebt =
    CALCULATE(
        MAX( myTable[Bad Debt Amount] ),
        ALLEXCEPT(
            myTable,
            myTable[Store],
            myTable[Order No],
            myTable[Customer No],
            myTable[Date/Time]
        )
    )
RETURN
    IF(
        vBadDebt > 0,
        "Bad Debt",
        myTable[Trans Type]
    )