Forum Discussion

gvg's avatar
gvg
Post Prodigy
9 years ago
Solved

What is contiguous selection?

Some functions only work with "contiguous selections". What are they exactly? For example,    Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column is not unique, has ga...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Right, but it's not a big deal :)   You need to create a separate date table, then relate your current table, to the date table.

     

    Probably the easiest way is to use New Table in the Modeling ribbon, and type "Dates = CALENDARAUTO()"

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Right, but it's not a big deal :)   You need to create a separate date table, then relate your current table, to the date table.

 

Probably the easiest way is to use New Table in the Modeling ribbon, and type "Dates = CALENDARAUTO()"

 

Anna_O's avatar
Anna_O
Frequent Visitor
5 years ago

Hi! Could you please help me? I created a new calendar table for reference, activated time intelligence, built a relationship between my two tables (calendar table and Sales data dump table), but can't figure out my formula now.

TotalSales LAST YEAR = Calculate([Total Sales],DATEADD('Sales Data Dump'[Posting Date],-1,YEAR))
I tried to use my date reference table instead - TotalSales LAST YEAR = Calculate([Total Sales],DATEADD('Calendar Table'[Date],-1,YEAR)) - but it's not working either.
 
My Total Sales are calculated this way: 
Total Sales = SUM('Sales Data Dump'[Sales Amount (Actual)])
 
I'm missing something...