- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-27-2017 06:59 AM

I got this one wrong because I used LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Sales[Date])) instead of LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))

What exactly is the difference between these 2 please?

Many thanks, all

## Re: Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-07-2017 12:43 AM

Could you provide error message?

## Re: Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-17-2017 10:54 AM

me too, I dont understand this difference. why do I need to use date from Date Table and cannot use date form Sales Table?

what kind of filters happen over this?

## Re: Lab 2 LY calculations

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-03-2017 08:46 PM - edited 03-03-2017 09:09 PM

Could you please provide an explanation? I got this wrong, also. Even after entering the DEX expressions from the Explanation (the answer...)

It is rediculous to plug in values from the "Answer", and still get an ncorrect value.

And no, I did not receive an error, just a Sales Var % of 0.03%.

Thanks,

EDIT: Nevermind, I found the answer in another post, where it mentioned that **the data type for Sales Var % simply needed to be of type Percentage**. Sheesh... It was not even intuative how to change the value type

## Re: Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-05-2017 11:27 PM

I also found the issue, if use Date type of Sales, the result about 0.03%. but if use Date type of Date table, the result is different, I think that the question's answer dependence on Instrcutor's demo in video, so if you want to get correct result, you can use the tip at the bottom of page

## Re: Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-13-2017 10:28 AM

Unfortunately the directions specify that you're looking for a comparison for "VanArsdel", but the correct answer requires analyzing the entire dataset without a filter.

## Re: Lab 2 LY calculations

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-13-2017 08:31 PM

You can refer the exercise2 first paragragh.