Forum Discussion

AmateurBI's avatar
AmateurBI
Regular Visitor
9 years ago
Solved

Column comparison

Hi everybody,   i'm completely unfamiliar with PowerBI and just started using ist two days ago. I am getting a list of product names every month. That list is constantly growing and already to big ...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    AmateurBI,

     

    You need to expand this table.

     

    Regards,

    Charlie Liao

     

AmateurBI's avatar
AmateurBI
Regular Visitor
9 years ago

Hey Charlie,

 

thank you so much for your reply! I tried to put whatever comes out of the in a new table with merge as new query (My PowerBi is in German, not sure whether translation is correct) because when I just tried to merge the queries this appeared:

 

 

This is the code that is displayed: = Table.NestedJoin(#"March",{"Names"},#"April",{"Names"},"NewColumn",JoinKind.LeftOuter)

 

So I don't really understand why PowerBi is just adding a new column? And there is only the expression "Table" in it?

 

When i put it in a new empty query it worked better, but now of course I can't really see the names that disappeared, but only the names that matched in both columns...

 

= Table.NestedJoin(#"March",{"Names"},#"April",{"Names"},"NewColumn.1",JoinKind.LeftOuter)

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

AmateurBI,

 

You need to expand this table.

 

Regards,

Charlie Liao

 

  • AmateurBI's avatar
    AmateurBI
    Regular Visitor
    9 years ago

    That was exactly, what I was looking for! Thank you so much