cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bw70316 Member
Member

Replace Values of cell upon load in Power Query?

I have data that I am not able to interact with from a database I don't personally have credentials to. Anyway, instead of states, the regions are classified as US/NC, US/GA, US/NJ, etc. I know I can replace data after it has been loaded, but is there a way to catch it have it changed when new data is refreshed into the report? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-danhe-msft
Microsoft

Re: Replace Values of cell upon load in Power Query?

Hi @bw70316 ,

Based on my research, you could try to use if condition to create a new column for your data to replace your former data:

https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/

https://community.powerbi.com/t5/Desktop/IF-Statement-using-Power-Query/td-p/122030

And it could work when you refresh your data.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Microsoft v-danhe-msft
Microsoft

Re: Replace Values of cell upon load in Power Query?

Hi @bw70316 ,

Based on my research, you could try to use if condition to create a new column for your data to replace your former data:

https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/

https://community.powerbi.com/t5/Desktop/IF-Statement-using-Power-Query/td-p/122030

And it could work when you refresh your data.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)