Forum Discussion
Helper IIIDistinctCount help with DATEADD only works with contigous date selections
I started cutting it down and editing it for privacy. As I removed a table, completely unrelated to anything I am doing here, suddenly it started working. I am not sure how the relationship was interfering with this,but after changing the relationship, (Both to Single) completely unrelated to this, it worked, Now I have to make sure that nothing else broke with this relationship change, but I got the problem figured out.
Thanx everyone.
Phil
Helper IIINo Joy.
CustomerCountPY= CALCULATE([CustomerCount], DATEADD('Date'[Date], -1, year))
Gives me the same "contiguous date selections" error.
Microsoft EmployeeHi psmith-nhs-inc,
Could you post your table structures with some sample data which can reproduce the issue? It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:
Regards
- psmith-nhs-inc
I started cutting it down and editing it for privacy. As I removed a table, completely unrelated to anything I am doing here, suddenly it started working. I am not sure how the relationship was interfering with this,but after changing the relationship, (Both to Single) completely unrelated to this, it worked, Now I have to make sure that nothing else broke with this relationship change, but I got the problem figured out.
Thanx everyone.
Phil