Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

SAMEPERIODLASTYEAR - Not showing data for last year, instead shows same data

Hello

I have created measure as follows -

PrevSales =
CALCULATE(SUM(FactInternetSales[SalesAmount]), SAMEPERIODLASTYEAR(DimDate[FullDateAlternateKey].[Date]))

However, it is not showing data for last year. Instead it shows same data. Below is the screenshot -

Any idea on this?

Regards

Anonymous
7 years ago
Anonymous,

Please drag year/date field of your DimDate table to table visual along with the PrevSales measure. You will get incorrect result if you drag year/date field of FactInternetSales table into table visual.

Regards,
Lydia

4 Replies

dujos
Helper I
7 years ago
Hello vmakhija,

First try to remove .[Date] in the end of your formula.

Below an example of the formula of mine:

PrevSales = CALCULATE([Total Sales]; SAMEPERIODLASTYEAR('Calendar'[Date]))
- Anonymous
  Not applicable
  7 years ago
  dujos
  Tried that. It gives all blanks for some reason -
  
  Regards
  - dujos
    Helper I
    7 years ago
    vmakhija, your data type on FactInternetSales[OrderDate] is the same of DimDate[FullDateAlternateKey]?
Anonymous
Not applicable
7 years ago
Anonymous,

Please drag year/date field of your DimDate table to table visual along with the PrevSales measure. You will get incorrect result if you drag year/date field of FactInternetSales table into table visual.

Regards,
Lydia