Forum Discussion

aaron1225's avatar
aaron1225
Helper 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 issue is here. 

Need Help

7 Replies

  • greggyb's avatar
    greggyb
    Resident Rockstar
    10 years ago

    Can you share the measure definitions you're using?

    • aaron1225's avatar
      aaron1225
      Helper 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
        Resident 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