Fill empty cells based on criteria

Hi AntanasK,

According to your description, you should be able to create a calculate column using DAX for the "Customer No_" column in this scenario. See my sample below.

I assume you have a table called "Table1" like below.

Then you should be able to use the formula below to create the calculate column for the "Customer No_".

New Customer No_ = 
VAR vidInio = Table1[Vidinio dok.nr.]
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Table1[Customer No_], 1 ),
        FILTER (
            ALL ( Table1 ),
            Table1[Vidinio dok.nr.] = vidInio
                && Table1[Customer No_] <> BLANK ()
                && Table1[Customer No_] <> ""
        )
    )

Here is the sample pbix file for your reference.:smileyhappy:

Regards