Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 2 Question 74 Discussion

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] ) )

Microsoft PL-300 Exam - Topic 2 Question 74 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 74
Topic #: 2
[All PL-300 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: A

Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.

DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.


https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

by Altha at Nov 22, 2025, 04:45 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Felix
3 months ago
D is interesting, but I still prefer B for simplicity and clarity.
upvoted 0 times
...
Selma
4 months ago
I feel like D is also a contender. MAX could give a clear ending balance.
upvoted 0 times
...
Lettie
4 months ago
A is good for quarterly data, but we need the last date for accuracy.
upvoted 0 times
...
Terrilyn
4 months ago
Not so sure about B. What about option A? DATESQTD could work too.
upvoted 0 times
...
Vallie
4 months ago
I agree, B seems solid. Ending balance needs the latest date.
upvoted 0 times
...
Arthur
4 months ago
Not sure about these options, they seem confusing.
upvoted 0 times
...
Raul
5 months ago
Wait, is option C even a valid DAX expression?
upvoted 0 times
...
Roosevelt
5 months ago
I always use option A for my reports.
upvoted 0 times
...
Glenn
5 months ago
I disagree, I think option D is better for that.
upvoted 0 times
...
Chauncey
5 months ago
Haha, this is a tricky one. I'll just guess and hope for the best!
upvoted 0 times
...
Yolando
6 months ago
C seems a bit weird, I'll go with B.
upvoted 0 times
...
Brent
6 months ago
D is the way to go, no doubt about it.
upvoted 0 times
...
Ronnie
6 months ago
I think A is the correct answer.
upvoted 0 times
...
Trinidad
6 months ago
I’m confused about FIRSTNONBLANK in option C. I don’t remember it being used for balance calculations, but I could be wrong.
upvoted 0 times
...
Maryann
6 months ago
I'm not entirely sure, but I remember practicing with DATESQTD before. It feels like it could be useful, but I don't know if it's the best for this question.
upvoted 0 times
...
Ben
6 months ago
I think option B might be the right choice since it uses LASTDATE, which seems relevant for getting the most recent balance.
upvoted 0 times
...
Joaquin
7 months ago
I'm pretty confident option B is the way to go. LASTDATE() is the key to getting the most recent balance, and SUM() will give me the total balance amount. Seems straightforward enough.
upvoted 0 times
...
Ulysses
7 months ago
Option A with DATESQTD() seems like it could work, but I'm worried that might give me the balance for the current quarter-to-date rather than the full ending balance. I'll have to double-check the documentation on that one.
upvoted 0 times
...
Mabelle
7 months ago
Option B looks good to me.
upvoted 0 times
...
Janna
7 months ago
Option B is the way to go for ending balances!
upvoted 0 times
...
Xenia
7 months ago
I think option B is the best choice. LASTDATE gives the most recent balance.
upvoted 0 times
...
Horace
8 months ago
I recall a similar question where we had to calculate year-end balances, and I think MAX could be important. So maybe option D?
upvoted 0 times
...
Herschel
8 months ago
Hmm, I'm a bit unsure about this one. I know we need to use CALCULATE() to filter the data, but I'm not sure if LASTDATE() or DATESQTD() is the better choice. I'll have to think this through a bit more.
upvoted 0 times
...
Margo
8 months ago
I think option B looks like the right approach here. We want the ending balance, so using LASTDATE() to get the most recent date seems like the way to go.
upvoted 0 times
Lenna
3 months ago
B is the best choice for getting the latest balance.
upvoted 0 times
...
Elenora
3 months ago
I was leaning towards option A, but B seems more accurate.
upvoted 0 times
...
Gilma
3 months ago
LASTDATE() is definitely the right function for this.
upvoted 0 times
...
Alaine
3 months ago
I agree, option B makes sense for ending balances.
upvoted 0 times
...
Hershel
8 months ago
Option D could work too, but B is simpler.
upvoted 0 times
...
...

Save Cancel