QuestionsCategory: PL-300HOTSPOT – You have a Power BI report. You have the following tables. You have the following DAX measure. Accounts := CALCULATE ( DISTINCTCOUNT (Balances[AccountID]), LASTDATE ('Date'[Date]) For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:
Admin Staff asked 4 months ago
HOTSPOT -
You have a Power BI report.
You have the following tables.
 Image
You have the following DAX measure.
Accounts :=
CALCULATE (
DISTINCTCOUNT (Balances[AccountID]),
LASTDATE ('Date'[Date])
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
 Image
















 

Suggested Answer: 
    Correct Answer Image

Box 1: No -
It will show the total number of accounts that were live at the last day of the year only.
Note:
DISTINCTCOUNT counts the number of distinct values in a column.
LASTDATE returns the last date in the current context for the specified column of dates.
Box 2: No -
It will show the total number of accounts that were live at the last day of the month only.
Box 3: Yes -
Reference:
https://docs.microsoft.com/en-us/dax/distinctcount-function-dax
 https://docs.microsoft.com/en-us/dax/lastdate-function-dax

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.

Welcome Back!

Login to your account below

Create New Account!

Fill the forms below to register

Retrieve your password

Please enter your username or email address to reset your password.