Forum Discussion
W2SANC
3 years agoHelper II
Merged Column Show Up in Power Query Editor but Columns are Empty in Data Tab & in Data Viz's
Hey! I recently followed the advice someone gave that worked on adding a column based on another columnn in another table by merging queries (see that post here https://community.fabric.microsof...
W2SANC
3 years agoHelper II
Additional information: Backing up to the step where I merged to get the FIPS code added to the main sales table - screenshot is below. Is how I expanded the column (where cells all say "table") what I am doing wrong?
First photo: what is seen after the merge. Second photo: what the options are when I click expand.
- amitchandak3 years agoSuper User
W2SANC , I doubt your join column values are not matching. can you check that
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.- W2SANC3 years agoHelper II
Truly new novice/beginner here, what do you mean by "check that" and I can make up a few small data point shortly in the next reply.