اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 42 من 50

كل الأسئلة

You have a semantic model that contains the following data:
The Date table relates to the Sales table
by using the Date columns.

The model contains the following DAX measure:
Total Sales = SUM(Sales[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected period.

Which DAX calculation should you use?

الخيارات

  • A TOTALQTD ( [Total Sales], Date[Date] )
  • B CALCULATE ( [Total Sales], PARALLELPERIOD ( Date[Date], 1, QUARTER ) )
  • C CALCULATE ( [Total Sales], DATEADD ( Date[Date], -1, QUARTER ) )
  • D CALCULATE ( [Total Sales], DATESQTD ( Date[Date] ) )

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.