Forum Discussion
how to correct error: Function 'DATEADD' expects a contiguous selection when the date column comes..
daxer-almighty : I have the periods selected in order i.e Jan and Feb. Anyway, i found the solution. It was with the relationship that was causing the issue. But thanks for your reply.
As the error says you can't have periods selected that are not contiguous to one another. So, if you select Jan and Feb in the same year it'll work, but if you select Jan and March, say, in the same year, it'll not work. Easy as that. If you want to be able to work with non-contiguous periods of time, you'll have to use GENERATE and go day by day shifting the days using DATEADD.
daxer-almighty : I have the periods selected in order i.e Jan and Feb. Anyway, i found the solution. It was with the relationship that was causing the issue. But thanks for your reply.
Can u please share what s wrong with the relation
Not OP, but I had a similar issue and it got solved by : Editing the relationship between the date and other table -> Change cross filter direction to "single".
