Forum Discussion

MojoGene's avatar
MojoGene
Post 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
Resolver 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
Post Patron
9 years ago

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

  • bblais's avatar
    bblais
    Resolver III
    9 years ago

    Are you using any filters or slicers on the date in your report?  If so, make sure they are not using the date column out of the fact table, but instead the date column out of the date table.

    • MojoGene's avatar
      MojoGene
      Post Patron
      9 years ago

      I was slicing the data on the page so that the DateBilled year included only the last 3 years, but one of the first things that occurred to me was to remove this slicer. Removing it had no effect on the error.

      • bblais's avatar
        bblais
        Resolver III
        9 years ago

        How about this instead of using SAMEPERIODLASTYEAR:

         

        Fees Billed SPLY = CALCULATE([Fees Billed YTD],DATEADD(Table_BasicCalendarUS[DateKey],-1,YEAR))