Given a column 'Sales' with text data type containing values like '100', '200', '300', what will be the result of this DAX measure after changing 'Sales' to Whole Number type?

medium📝 dax lod result Q13 of 15

Power BI - Power Query Editor

Given a column 'Sales' with text data type containing values like '100', '200', '300', what will be the result of this DAX measure after changing 'Sales' to Whole Number type?

Total Sales = SUM('Table'[Sales])

AIt will return an error because SUM cannot be used on numbers

BIt will concatenate the text values: '100200300'

CIt will sum the numbers correctly: 600

DIt will return zero because the column is text

Step-by-Step Solution

Solution:

Step 1: Understand the effect of changing 'Sales' to Whole Number
Changing 'Sales' from text to whole number converts values like '100' to 100 as numbers.
Step 2: Evaluate the SUM function on numeric data
SUM adds numeric values, so 100 + 200 + 300 = 600.
Final Answer:
It will sum the numbers correctly: 600 -> Option C
Quick Check:
SUM of numbers = 600 [OK]

Quick Trick: SUM works only on numeric data types [OK]

Common Mistakes:

Expecting SUM to concatenate text
Thinking SUM causes error on numbers
Assuming text columns sum to zero

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

Given a column 'Sales' with text data type containing values like '100', '200', '300', what will be the result of this DAX measure after changing 'Sales' to Whole Number type?

Step 1: Understand the effect of changing 'Sales' to Whole Number

Step 2: Evaluate the SUM function on numeric data

Final Answer:

Quick Check:

Want More Practice?