Forum Discussion

vijenkin's avatar
vijenkin
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Replace Values in Column with another Value

Hello I am currently trying to replace values in one column based on set criteria. I did some research and while I see a number of topics that talk about replacing a value in column A if value in col...
Need Help
calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi vijenkin,

 

In the Power Query editor, try using merge Table1 and Table2 on Account so you get the column Companies, then Remove column Account, close and apply. This is the result:

Merge on AccountExpand CompaniesRemove AccountTableVisual

 

This will be refreshed based on the schedule you define in the PBI Service.

Hope it helps.

Regards,

Fernando