Exam PL-300 topic 2 question 29 discussion

Calculate Sum DatesBetween

Calculate Sum DatesBetween Suggested SamePeriodLastYear expects only 1 parameter: column containing dates

The last one is datesbetween: from MS documentation DATESBETWEEN(<Dates>, <StartDate>, <EndDate>). SAMEPERIODLASTYEAR(<dates>) takes only 1 mandatory argument

CALCULATE SUM DATESBETWEEN it could be misleading the "startyear" and "endate" labels as there is no explicit mention this VARS (calculated above in the DAX expression) are retuning PREVIOUS YEAR startdate and enddate. Also, as mentioned by several others, the SAMEPERIODLASTYEAR function requires one single argument ([Date])

You can use SAMEPERIODLASTYEAR but in this case 3 arguments are required so we need to use DatesBetween because there are three arguments. So I would say: CALCULATE, SUM, DATESBETWEEN

Calculate Sum DatesBetween -- I always look for the number of arguments necessary: DATESBETWEEN(<Dates>, <StartDate>, <EndDate>) SAMEPERIODLASTYEAR(<dates>)

CALCULATE, SUM and DATESBETWEEN. DATESBETWEEN because the variables that are declared already contain the dates of last year.

Calculate Sum Datesbetween

Who decides on website's final answer? We need to understand his/her level of confidence. Maybe he got the answers from Microsoft.

The location of the formula text in between the images is a bit poorly chosen. It makes it seem like the order is: Option box 1 > ( Sales [sales] ), Option box 2. Even though that wouldn't obviously be possible

hmm thanks for the explanation. Calculate, sum, datesBetween

Calculate Sum DatesBetween

Correct Answer : Calculate, Sum, and DateBetween The DATESBETWEEN function is used to filter a table or a column of dates to a specified date range. It takes two arguments: the first argument is the date column to filter, and the second and third arguments are the start and end dates of the desired date range, respectively. The function returns a table of dates that fall within the specified range. On the other hand, the SAMEPERIODLASTYEAR function is used to retrieve the same period (week, month, quarter, or year) as the one currently selected, but from the previous year. It takes one argument, which is the date column to use as a reference, and returns a table of dates from the previous year that match the current period. This function is often used to compare data across time periods, such as comparing sales in the current year to sales in the same period of the previous year.

Correct Answer : Calculate, Sum, and DateBetween The DATESBETWEEN function is used to filter a table or a column of dates to a specified date range. It takes two arguments: the first argument is the date column to filter, and the second and third arguments are the start and end dates of the desired date range, respectively. The function returns a table of dates that fall within the specified range. On the other hand, the SAMEPERIODLASTYEAR function is used to retrieve the same period (week, month, quarter, or year) as the one currently selected, but from the previous year. It takes one argument, which is the date column to use as a reference, and returns a table of dates from the previous year that match the current period. This function is often used to compare data across time periods, such as comparing sales in the current year to sales in the same period of the previous year. No confusion, and no need to further discussion

Answer is correct Calculate Sum Sameperiodlstyear no confusion

Calculate Sum DatesBetween * Sales Last Year = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])) * Total Sales Q1 = CALCULATE(SUM(Sales[Amount]), DATESBETWEEN(Sales[Date], DATE(2022,1,1), DATE(2022,3,31))) * DatesBetween expects 3 parameters as per the exhibit, SamePeriodLastYear expects one parameter

Calculate Sum DatesBetween