156-315.81 Exam Discussions & Posts
anonyBR
Commented on June 15, 2025
Q103
Percent of Product Sales =
VAR ProductSales = SUM ( 'Sales'[Sales] )
VAR AllSales =
CALCULATE (
SUM ( 'Sales'[Sales] ),
ALLSELECTED ( 'Products'[Product] )
)
RETURN
DIVIDE ( ProductSales, AllSales )
Anonymous
anonyBR
Commented on June 15, 2025
q93:
Transaction Size =
VAR SalesTotal = 'Sales'[Sales Amount]
VAR FilterSegment =
FILTER (
'Transaction Size',
'Transaction Size'[Min] <= SalesTotal &&
'Transaction Size'[Max] >= SalesTotal
)
VAR Result =
CALCULATE (
DISTINCT ( 'Transaction Size'[Transaction Size] ),
FilterSegment
)
RETURN Result
Anonymous
Anony
Commented on June 15, 2025
Q91:
Yes
Sales by Delivery Date :=
CALCULATE (
SUM ( Sales[Amount] ),
USERELATIONSHIP ( Sales[DeliveryDate], 'Date'[Date] )
)
Anonymous
Anony
Commented on June 14, 2025
q83:
Use First Row as Headers
Select Department and Product and Unpivot Other Columns
Rename the Attribute column to Year and the Value column to Revenue
Anonymous
Anony
Commented on June 14, 2025
Q78:
Sales PYTD =
VAR startyear =
STARTOFYEAR ( PREVIOUSYEAR ( 'calendar'[Date] ) )
VAR enddate =
LASTDATE ( Sales[Date] ) - 365
RETURN
CALCULATE (
SUM ( Sales[Sales] ),
DATESBETWEEN ( 'calendar'[Date], startyear, enddate )
)
Anonymous