← Back to exam page

DA-100 – Analyzing Data with Microsoft Power BI

Loading demo links...

Showing 7–9 of 10 questions

Question 7 (Mixed Questions)

You have a table maned Sales that contains sales data by sales person.

You want to create a visual that shows the top 5 performing sales persons based on their total sales value.

You use the following DAX function:

TOPN(5, Sales, orderBy (SalesPerson, TotalSales))

Does this action show the top 5 performing sales persons based on sales value?

Select an option, then click Submit answer.

  • ○

    Yes, it does
  • ○

    No, it does not
Question 8 (Mixed Questions)

You want to use Power Query Editor to quickly ascertain the percentage of empty values in each column.

You open the Column distribution Data Preview option

Does this action allow you to ascertain the percentage of empty values in each column?

Select an option, then click Submit answer.

  • ○

    Yes, it does
  • ○

    No, it does not
Question 9 (Case Study 3)

Which DAX expression should you use to get the ending balances in the balance sheet reports?

Select an option, then click Submit answer.

  • ○

    CALCULATE (
    SUM( BalanceSheet [BalanceAmount] ),
    DATESQTD( 'Date'[Date] )
    )
  • ○

    CALCULATE (
    SUM( BalanceSheet [BalanceAmount] ),
    LASTDATE( 'Date'[Date] )
    )
  • ○

    FIRSTNONBLANK ( 'Date' [Date]
    SUM( BalanceSheet[BalanceAmount] ) )
  • ○

    CALCULATE (
    MAX( BalanceSheet[BalanceAmount] ),
    LASTDATE( 'Date' [Date] )
    )