Count Value Once in Column

Anonymous ,

You may add a new value to discriminate if the ReceiptNumber is the first instance per ReceiptDate like below:

New Sale =
VAR IDCount =
    CALCULATE (
        COUNTROWS ( GetReceiptsData ),
        ALLEXCEPT ( GetReceiptsData, GetReceiptsData[UnitRefNo] )
    ) = 1
VAR First_Date =
    GetReceiptsData[ReceiptDate]
        = CALCULATE (
            FIRSTDATE ( GetReceiptsData[ReceiptDate] ),
            ALLEXCEPT ( GetReceiptsData, GetReceiptsData[UnitRefNo] )
        )
VAR First_Instance =
    GetReceiptsData[ReceiptNumber]
        = CALCULATE (
            FIRSTDATE ( GetReceiptsData[ReceiptNumber] ),
            ALLEXCEPT ( GetReceiptsData, GetReceiptsData[UnitRefNo] )
        )
RETURN
    IF ( AND ( OR ( IDCount, First_Date ), First_Instance ), "New Sale" )

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.