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