Which DAX expression formats the number to display 20.00%?

Prepare for the Power BI Certification Exam with interactive quizzes and detailed explanations. Improve your understanding of Power BI with comprehensive study materials and practice questions. Get exam-ready today!

The DAX expression that correctly formats the number to display 20.00% is recognized as the appropriate choice because it converts the decimal value representing 20% into a percentage format correctly. In DAX, when using the FORMAT function, the input should reflect the decimal equivalent of the percentage.

In this case, 0.2 represents 20% when formatted as a percentage. When applying the FORMAT function with the string "Percent", it translates the decimal (0.2) into the percentage form of 20.00%. The result adheres to the requested two decimal places, achieving the expected output accurately.

Looking at the other values: 20 is interpreted as 20,000% since no decimal is provided to indicate a proportion. The input of 2 signifies 200%, also far beyond the desired format. Although 0.20 is a decimal representation of 20%, when the format "Percent" is applied, it does not ensure two decimal places, which might lead to a result of 20%. Therefore, option B stands out as the only one that meets both the numerical representation and the formatting criteria accurately.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy