- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Modify a conditional column
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-08-2016 08:31 AM - edited 11-08-2016 08:32 AM
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 some changes?
Kind regards,
Matt
Solved! Go to Solution.
Accepted Solutions
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-14-2016 06:24 AM
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
All Replies
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-08-2016 08:53 AM
Click on your column and you should see the formula in the bar just above the table. Or are you doing this in the Query Editor?
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-09-2016 12:56 AM
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
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-14-2016 06:24 AM
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
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-07-2017 05:11 AM
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
Re: Modify a conditional column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-30-2018 12:37 AM
That's right Ricardo, thanks.