NULL assigned unique individual values

Hi Anonymous 

I have in the passed replaced NULLs using the INDEX feature.

In the Query editor | Add Columns | Index from then enter the MAX index you have.

I then said if the Original ID is null use the new id else use the original id.

Delete the old ID and rename this column.

Hi Anonymous ,

It can be done both ways.

M code.

if [Entry No] = null and [PO] = 116557 and [Creditor Name] = "Advanced Travel Partners UK Ltd" and [Creditor Code] = 410229 and [transtype] = "B"
then "N"
else [transtype]

DAX.

Column =
IF (
    'Table'[Entry No] = BLANK ()
        && 'Table'[PO] = 116557
        && 'Table'[Creditor Name] = "Advanced Travel Partners UK Ltd"
        && 'Table'[Creditor Code] = 410229
        && 'Table'[transtype] = "B",
    "N",
    'Table'[transtype]
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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