Câu 5: 70-778: Analyzing and Visualizing Data with Microsoft Power BI
You have a Power BI model that contains the following tables: ✑ Sales (Sales_ID, DateID, sales_amount) ✑ Date (DateID, Date, Month, week, Year)The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months. Which DAX form…
Nội dung câu hỏi
You have a Power BI model that contains the following tables: ✑ Sales (Sales_ID, DateID, sales_amount) ✑ Date (DateID, Date, Month, week, Year)The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months. Which DAX formula should you use?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (‘Date’ [Date]))
- B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (‘Date’ [Date]))
- C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(‘Date’[Date])) — đáp án hiện tại
- D. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]),DATESYTD(‘Date’[Date]))
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.