Forum Discussion

aaron1225's avatar
aaron1225
Icon for Helper I rankHelper I
10 years ago

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...
Need Help
aaron1225's avatar
aaron1225
Icon for Helper I rankHelper I
10 years ago

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]))

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Can you confirm the following?

  1. The relationship is between the two fields named [Date]
  2. These fields have Data Type set to Date (note, not Data Format - that is distinct from Data Type)
  3. There are no other filters applied in this report on dimDate
  4. 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
  • aaron1225's avatar
    aaron1225
    Icon for Helper I rankHelper I
    10 years ago

    Thanks for giving me a hand... checked the below

     

    Can you confirm the following?

    1. The relationship is between the two fields named [Date] Yes single direction
    2. These fields have Data Type set to Date (note, not Data Format - that is distinct from Data Type) Yes Data Type = Date
    3. 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
    4. 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. 
    • greggyb's avatar
      greggyb
      Icon for Resident Rockstar rankResident Rockstar
      10 years ago

      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?

      • aaron1225's avatar
        aaron1225
        Icon for Helper I rankHelper I
        10 years ago

        Thank you for your help, looks like I can resolve the issue if I clear my date filter on the data query before loading the table to my data model as well as to turn off my Total Column on the table.  Maybe this will help someone else in the future.  Thanks again.