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. 

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.

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

      Ok, I'm thinking it's something to do with the fact that your Fees Billed measure is filtering by BillSubType.  So what's happening is that it's coming up with blanks for some of the past year's dates when it's trying to calculate the Fees Billed and it doesn't like it.

       

      For the heck of it, can you try adding +0 to your Fees Billed formula:

       

      Fees Billed = CALCULATE(SUM(FactTable[AmtBilledForSubtype])+0,FactTable[BillSubtype]="FEE")

      I know this won't fix the issue necessarily, but it would confirm what's going on.

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

        I tried the suggestion, but it had no apparent effect on any of the 3 measures.