Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Combine replace value steps?

Me again,   I am combining steps to clean up my Query Editor. E.g. Renaming columns all in one step rather than all over the shop.  I want to combine Table.ReplaceValue steps but it doesn't seem t...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

I would suggest you provide a dummy pbix file. We can give you a solution with details in the file. If you'd like to share a file, you can upload it to the cloud drive like OneDrive, GoogleDrive, then share the download link here. Please don't share sensitive data here.

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dale,

 

Sorry for the delay in response.

 

I cannot attach the dataset but I have screenshots of what i'm talking about. 

So I have 20 Replaced Value steps. 

 

I had about the same number of steps for Renamed Columns and Changed Type, and I was able to combine these steps into one single step each using M-Query in the formula bar by using curly brackets and coma separators. 

 

I want to do the same for the Replaced Value steps. However applying the same logic as I did for the Renamed Columns steps, does not work for Replaced Value. 

 

So to summarise, I am wondering if it is possible to combine 'Replaced Value' Applied Steps using M-Query in the formula bar. 

 


Example of where I have combined multiple steps of renaming columns by splitting using {},First Replace Value StepSecond Replace Value StepThird Replace Value StepApplied steps shows all the Replaced Value Steps