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
greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Can you share the measure definitions you're using?

  • 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.