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

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
Vallie
2 days ago
I agree, B seems solid. Ending balance needs the latest date.
upvoted 0 times
...
Arthur
7 days ago
Not sure about these options, they seem confusing.
upvoted 0 times
...
Raul
25 days ago
Wait, is option C even a valid DAX expression?
upvoted 0 times
...
Roosevelt
1 month ago
I always use option A for my reports.
upvoted 0 times
...
Glenn
1 month ago
I disagree, I think option D is better for that.
upvoted 0 times
...
Chauncey
1 month ago
Haha, this is a tricky one. I'll just guess and hope for the best!
upvoted 0 times
...
Yolando
2 months ago
C seems a bit weird, I'll go with B.
upvoted 0 times
...
Brent
2 months ago
D is the way to go, no doubt about it.
upvoted 0 times
...
Ronnie
2 months ago
I think A is the correct answer.
upvoted 0 times
...
Trinidad
2 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
2 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
2 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
3 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
3 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
3 months ago
Option B looks good to me.
upvoted 0 times
...
Janna
3 months ago
Option B is the way to go for ending balances!
upvoted 0 times
...
Xenia
3 months ago
I think option B is the best choice. LASTDATE gives the most recent balance.
upvoted 0 times
...
Horace
4 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
4 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
4 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
Hershel
4 months ago
Option D could work too, but B is simpler.
upvoted 0 times
...
...

Save Cancel