Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
gianmarco
Helper IV
Helper IV

Reference column from another table for a List

Dear All,

I have the following table:


Table1

CODEVALUE
7241.000

323

500

null

200
455300
null1.200
444600
256700

 

What I want is:

in column CODE, replace "null" with a list of all the distinct codes existent in column CODE except "null".

MSo instead of nulls I get a list of the following elements {724, 323, 455, 444, 256} 

 

I achieve this throught the following step:

 

= Table.TransformColumns( #"previous step", {{"CODE", (x)=> if x = null then List.Select(List.Distinct( #"previous step"[CODE]), each _<> null) else {x}}})

 

 

Now, I have another table with a list of codes:

 

Table2

CODEVALUE
123100

829

100
047150
299300

 

My question is: How do I reference CODE column in Table 2 in the previous step INSTEAD of CODE column in Table1?


Thanks for your time

gianmarco

1 REPLY 1
lbendlin
Super User
Super User

You use any of the merge operations - like Table.AddColumn, joins, or index lookups.

 

What is your expected outcome based on the sample data?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.