PL-300 · Question #453
You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date…
The correct answer is B. 15. When a Power BI report has a page-level filter set to a specific date, a DAX measure using PREVIOUSYEAR will return the value for the corresponding single date in the prior year.
Question
You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data. Model1 contains the following measure. Previous Year Sales = CALCULATE([Sales Amount], PREVIOUSYEAR('Date'[Date])) You have a report that uses Model1. The report has a single report page that has a page level filter set to May 9, 2024. The result of the Previous Year Sales measure is displayed in a card visual. Which value will appear in the card visual?
Options
- A10
- B15
- C35
- D60
How the community answered
(42 responses)- A2% (1)
- B79% (33)
- C14% (6)
- D5% (2)
Why each option
When a Power BI report has a page-level filter set to a specific date, a DAX measure using `PREVIOUSYEAR` will return the value for the corresponding single date in the prior year.
10 is the sales amount for May 8, 2023, which is not the specific date derived by PREVIOUSYEAR from May 9, 2024.
The `PREVIOUSYEAR` function, when used with a filter context of a single date like May 9, 2024, shifts that specific date to the corresponding date in the previous year, which is May 9, 2023. Therefore, the `Previous Year Sales` measure calculates the Sales Amount for May 9, 2023, which is 15 according to the provided FactSales data.
35 is the sales amount for May 9, 2024, representing the current year's sales, not the previous year's as required by the measure.
60 is an arbitrary sum that does not align with the `PREVIOUSYEAR` calculation for a single date context.
Concept tested: DAX time intelligence functions (PREVIOUSYEAR) with filter context
Source: https://learn.microsoft.com/en-us/dax/previousyear-function-dax
Community Discussion
No community discussion yet for this question.