Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago
Solved

Modify a conditional column

Hi,   I have a pretty basic question, but I can't seem to find the answer. I have created a conditional column in one of my tables. How can I modify these conditions afterwards if I want to make so...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Matthias93

     

    If you want to add the condition column in Query Editor, you can add custom column with Power Query syntax. 

     

    if [Column1] = "a" then 0 else 1

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago

Hi,

 

Thank you for your help, but I am indeed doing this in de query editor where I put 10 conditional lines (if X then Y), how can I change these lines from the editor?

 

Kind regards,

Matt

RicardoS's avatar
RicardoS
Icon for Advocate III rankAdvocate III
9 years ago

Hi Matthias93,

 

Maybe a little bit too late, but I don't think the reply (that is marked as solution) answered your question. You want to modify your Custom Column in the Query Editor.

To do this, go to your Applied Steps in the Query Settings (on the right side). Then click on the settings icon and then you can change your query. More information here.

 

Kind regards,

Ricardo

 

 

  • jasbirs's avatar
    jasbirs
    New Member
    8 years ago

    That's right Ricardo, thanks.