Microsoft Power BI Data Analyst PL-300 Question # 49 Topic 5 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 49 Topic 5 Discussion

PL-300 Exam Topic 5 Question 49 Discussion:
Question #: 49
Topic #: 5

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.