Forum Discussion
Contiguous Date Error
I have tried a number of work arounds but I am still receiving an error for Contiguous Date Selection, this is page view data from Google Analytics with my standard date table, not sure what the issu...
Can you share the measure definitions you're using?
Here are the DAX I am using -- I have tried wraping the LY New User in a SumX and have changed the date filter to single direction based on suggestions in the user forum, nothing worked yet
Sum New Users = SUM('Main Domain + Sub-domain Data (Filtered)'[New Users])
LY New Users = CALCULATE([Sum New Users],SAMEPERIODLASTYEAR(dimDate[Date]))
Can you confirm the following?
- The relationship is between the two fields named [Date]
- These fields have Data Type set to Date (note, not Data Format - that is distinct from Data Type)
- There are no other filters applied in this report on dimDate
- The field dimDate[Date] spans the period from January 1 in the first year you have data to December 31 in the last year you have data with no gaps between dates
Thanks for giving me a hand... checked the below
Can you confirm the following?
- The relationship is between the two fields named [Date] Yes single direction
- These fields have Data Type set to Date (note, not Data Format - that is distinct from Data Type) Yes Data Type = Date
- There are no other filters applied in this report on dimDate = No filters on the report -- I did filter in the query to date>1/1/2015
- The field dimDate[Date] spans the period from January 1 in the first year you have data to December 31 in the last year you have data with no gaps between dates = Yes double checked this.
This is perplexing. Typically one of those is the culprit. Any chance you could share your .pbix file (hosted on OneDrive or similar)? Or, could you prepare a sample wherein you can reproduce this issue that you could share?