Forum Discussion

MojoGene's avatar
MojoGene
Icon for Post Patron rankPost Patron
9 years ago
Solved

SAMERPERIODLASTYEAR - Non Contiguous Date Selection Error

I've read multiple posts on this error: "SAMEPERIODLASTYEAR expects a contiguous selection when the date column comes from a table on the 1-side of a bidirectional relationship." I am still baffled b...
Need Help
  • MojoGene's avatar
    MojoGene
    9 years ago

    I get the same exact error message. 

bblais's avatar
bblais
Icon for Resolver III rankResolver III
9 years ago

Just curious, is your Table_BasicCalendarUS[DateKey]) of type date or something else?

  • MojoGene's avatar
    MojoGene
    Icon for Post Patron rankPost Patron
    9 years ago

    It is definitely a date table.

    • bblais's avatar
      bblais
      Icon for Resolver III rankResolver III
      9 years ago

      I mean the DateKey column specifically?

      • MojoGene's avatar
        MojoGene
        Icon for Post Patron rankPost Patron
        9 years ago

        Yes, I should have been more specific. The DateKey column is type date.