SAME INVOICE NO. replicate the type if blank

[Easley08]

Hi, 

is there a way to copy the trans_type to the blank value using dax? 

sample 

Thanks.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the  below picture and the attached pbix file.

It is for creating a new column.

trans_type_fill CC = 
VAR _CurrentRowInvoice = data[invoice_no]
VAR _CurrentRowDueDate = data[due_date]
VAR _t =
    FILTER (
        data,
        data[invoice_no] = _CurrentRowInvoice
            && data[due_date] = _CurrentRowDueDate
            && data[net_amount] == 0
    )
VAR _transtype =
    SUMMARIZE (
        _t,
        data[trans_type]
    )
RETURN
    _transtype