Forum Discussion
Matthias93
9 years agoHelper III
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...
- 9 years ago
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
9 years agoHelper III
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
v-sihou-msft
9 years agoMicrosoft Employee
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