Conditional Column in Power BI

24-01-2019  0 Comment(s)

Power BI Conditional column generate a new column based on the condition that we specify. For example, creating an appraisal column based on the employee performance etc. In order to add conditional column, please click Edit Queries option under the Home tab. Clicking Edit Queries option will open a new window called Power Query Editor. In this example, we are going to use the Sales column. First, go to Add Column Tab. Under this tab, you can see the Conditional Column button. You can use this button to add the conditional column on this table. We changed the Column name as Rating. Next, we selected the Column name as SalesNext, we selected the Operator as greater than, and value as 3000. Within the Values or Output text box, either you can give the static values or you can select the column.You can use the ….. button to move selected Rule to up and down, or you can delete it as well. For now, we are leaving as it is, and click OK button

Comment Here


No Comments to Show