- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LY Sales Measure is displaying current year sales
Hello everyone, I created a measure for last year sales and plan to do the same for 2 years back. I created the following measure:
Here are my relationships. As you can see, store #s are connected to a master store list, and dates are connected to a date table
Thank you in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Since you have a date table, you should use the date of your date table and not the one from the fact table.
One more thing do not forget to mark your date table as a date table, and to link (seems done on your screencopy).
But the stange thing is that you might have forgotten something, because if your date is related to your date table or coming from the date table, you should not see the date hierarchy (Date.Year or Date.Month...).
So that's why I'm guessing your table is not marked or linked properly 😉
Let us know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, Yes I selected the Date column from the Coupon table, but even when I select the date from the date table, the values for LY = current sales
Here are the relationships
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
WOW thank you, I feel dumb.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No worries it happens to all of us...
and dumbness is well shared amongst all of us, with an equal distribution 😉

Helpful resources
User | Count |
---|---|
14 | |
13 | |
10 | |
10 | |
8 |
User | Count |
---|---|
19 | |
17 | |
14 | |
13 | |
11 |