New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

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

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

PL-300 Exam Topic 5 Question 41 Discussion:
Question #: 41
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.