Microsoft Power BI Data Analyst PL-300 Question # 20 Topic 3 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 20 Topic 3 Discussion

PL-300 Exam Topic 3 Question 20 Discussion:
Question #: 20
Topic #: 3

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


A.

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


B.

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


C.

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


D.

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


Get Premium PL-300 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.