Forum Discussion
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...
I get the same exact error message.
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.
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.