Which command should you use in Query Editor?

Note This question it part of a series of questions that use the same scenario. For your convenience, the scenario is repeated In each question Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button)

You plan to develop a Power BI model at shown in the Power BI Model exhibit (Click the Exhibit button)

You plan to use Power BI to import data from 2013 to 2015

Product Subcategory[Subcategory] contains NULL values.

You implement the Power BI model

You need to add a new column to the Product Subcategory table that uses the following formula.

-if [Subcategory]-null then “NA” else [Subcategory]

Which command should you use in Query Editor?

A . Column from Examples?
B . Column Column
C . Invoke Custom Function
D . Conditional Column

View Answer

Answer: C