Forum Discussion
What is contiguous selection?
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()"
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()"
We are facing this issue in those cases when sale of a particular brand was not in previous year but it is in current year. How can we resolve this issue if getting the same error? (Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column is not unique, has gaps or it contains time portion.). Is there any way to define last year value as zero for all those cases where no value exists? I have tried with IFERROR and HASONEVALUE but these are also not working.