SAME INVOICE NO. replicate the type if blank

Easley08 — Tue, 15 Oct 2024 03:39:52 GMT

Hi,

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

sample

Thanks.

Re: SAME INVOICE NO. replicate the type if blank

Jihwan_Kim — Tue, 15 Oct 2024 03:58:38 GMT

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

topic SAME INVOICE NO. replicate the type if blank in DAX Commands and Tips

SAME INVOICE NO. replicate the type if blank

Re: SAME INVOICE NO. replicate the type if blank