Exam DA-100 topic 9 question 1 discussion

Ans - CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) ) https://docs.microsoft.com/en-us/learn/modules/create-measures-dax-power-bi/5-semi-additive-measures

Ans. is A. 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.

Quarterly reporting of balance sheet accounts should refer to the value of the last month of the quarter. So it should use semi-additive measure

B is correct answer

I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.

I understand that SUM is the perfect function combined with LASTDATE, but I have a problem with the sign. The balance is showing two asset accounts and one liability account. We can't make the direct sum of things that are the opposite. The assets minus liabilities and net worth are always equal to zero, but the example does not show all the accounts. Some good question would be: 1* which is the Balance Amount for the assets every month, quarter, etc.? In this case we should sum only the asset accounts (cash and inventories) 2* which is the working capital? This are short term assets minus short term liabilities. But there are two problems. They are giving us long-term liabilities, not short-term ones. And we need to change the sign before summing.

I think the answer should be D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )

In exam

on exam 12/10/2021

DATESQTD is going to return multiple dates and you don't want to sum all of those dates b/c the value you have for each date is the balance on that date, so it's LASTDATE (IMO).

A: You must not sum balance values. They are already sums. Every following balance value includes the previous values. DATESQTD: Delivers a table of dates including every (used) date of the current quarter of the filter context. -> sums every monthly balance value of a quarter -> bad LASTDATE: Delivers a table of exactly one date. The last (used) date in the filter context. -> sums the last balance value a quarter -> nice

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. - https://docs.microsoft.com/en-us/dax/datesqtd-function-dax#example

on exam - Nov 11, 2021. my answer: CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )

On exam 10/14/21

https://community.powerbi.com/t5/Desktop/Power-Pivot-DAX-Balance-sheet-averages/td-p/473904

I am very confused - is there even any relationship that has been established between the balance sheet table and the date table??

What is the purpose of using the SUM function here?