Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

You have a semantic model that contains two tables named Sales and Date.

Microsoft PL-300 Full Course Access
Microsoft PL-300 View All Questions

You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:

• Date

• Product

• SalesAmount

You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.

Which DAX expression should you use?

A.

CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-36, Max('Date'[Date])))

B.

CALCUlATE(SUM

C.

CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)

D.

CALCULATE(SUM(Sales[SalesAmount]), DATESHTD(Date[Date]))

PL-300 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now PL-300 pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
You are creating a sales report in Power Bl for the NorthWest region sales territory...
Note: This question is part of a series of questions that present the same scenario.
Previous