Forum Discussion

pani_victoria's avatar
pani_victoria
Helper III
2 years ago
Solved

blank row

Good afternoon, colleagues! I would like to combine column values from 3 tables into a separate table. I use Counterparties = var A01 = ALLNOBLANKROW('Receipts'[Counterparty]) var A02 = AL...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Counterparties =
var A01 = ALLNOBLANKROW('Receipts'[Counterparty])
var A02 = ALLNOBLANKROW('Payment orders'[Counterparty])
var A03 = ALLNOBLANKROW('Accounting for responsible persons'[Counterparty])
VAR partners = DISTINCT(FILTER(UNION(A01, A02, A03),[Counterparty]<> BLANK()))
return
partners
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

Counterparties =
var A01 = ALLNOBLANKROW('Receipts'[Counterparty])
var A02 = ALLNOBLANKROW('Payment orders'[Counterparty])
var A03 = ALLNOBLANKROW('Accounting for responsible persons'[Counterparty])
VAR partners = DISTINCT(FILTER(UNION(A01, A02, A03),[Counterparty]<> BLANK()))
return
partners
pani_victoria's avatar
pani_victoria
Helper III
2 years ago

But could you explain why it doesn't work ALLNOBLANKROW?