Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Power BI Data Analyst Associate
  5. PL-300 Discussions
  6. PL-300 Exam Topic 10 Question 91 Discussion
 Microsoft Discussions
Exam PL-300 All Questions
Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Go to Exam

Microsoft Certified: Power BI Data Analyst Associate PL-300 Question # 91 Topic 10 Discussion

PL-300 Exam Topic 10 Question 91 Discussion:
Question #: 91
Topic #: 10

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
Actual exam question for Microsoft PL-300 exam by Eris3064 at May 3, 2026, 6:10:27 PM

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.

Submit