Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 = ALLNOBLANKROW('Payment orders'[Counterparty])
var A03 = ALLNOBLANKROW('Accounting for responsible persons'[Counterparty])
VAR partners = DISTINCT(UNION(A01, A02, A03))
return
partners
The output I get is the values + an empty string.
I don't understand why it appears if I use ALLNOBLANKROW. How to remove it?
Solved! Go to Solution.
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
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
But could you explain why it doesn't work ALLNOBLANKROW?
Thanks a lot! It works!!! 😄
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
88 | |
77 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |