MENU
Which DAX expression should you use to get the ending balances in the balance sheet reports?
Suggested Answer: A
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
29 comments · newest first
FE
Felix
6 months ago
D is interesting, but I still prefer B for simplicity and clarity.
SE
Selma
7 months ago
I feel like D is also a contender. MAX could give a clear ending balance.
LE
Lettie
7 months ago
A is good for quarterly data, but we need the last date for accuracy.
TE
Terrilyn
7 months ago
Not so sure about B. What about option A? DATESQTD could work too.
VA
Vallie
7 months ago
I agree, B seems solid. Ending balance needs the latest date.
AR
Arthur
7 months ago
Not sure about these options, they seem confusing.
RA
Raul
8 months ago
Wait, is option C even a valid DAX expression?
RO
Roosevelt
8 months ago
I always use option A for my reports.
GL
Glenn
8 months ago
I disagree, I think option D is better for that.
CH
Chauncey
8 months ago
Haha, this is a tricky one. I'll just guess and hope for the best!
YO
Yolando
9 months ago
C seems a bit weird, I'll go with B.
BR
Brent
9 months ago
D is the way to go, no doubt about it.
RO
Ronnie
9 months ago
I think A is the correct answer.
TR
Trinidad
9 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.
MA
Maryann
9 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.
BE
Ben
9 months ago
I think option B might be the right choice since it uses LASTDATE, which seems relevant for getting the most recent balance.
JO
Joaquin
10 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.
UL
Ulysses
10 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.
MA
Mabelle
10 months ago
Option B looks good to me.
JA
Janna
10 months ago
Option B is the way to go for ending balances!
XE
Xenia
10 months ago
I think option B is the best choice. LASTDATE gives the most recent balance.
HO
Horace
11 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?
HE
Herschel
11 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.
MA
Margo
11 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.
LE
Lenna
6 months ago
B is the best choice for getting the latest balance.
EL
Elenora
6 months ago
I was leaning towards option A, but B seems more accurate.
GI
Gilma
6 months ago
LASTDATE() is definitely the right function for this.
AL
Alaine
6 months ago
I agree, option B makes sense for ending balances.
HE
Hershel
11 months ago
Option D could work too, but B is simpler.