Forum Discussion

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago
Solved

Contiguous error...PY and PY YTD

I know this has been addressed in other posts, but I can't seem to get this issue resolved.  I'm using the following formula: PY = CALCULATE([Sales],DATEADD('Accounting Date'[FULL_DATE],-1,YEAR),all...
  • blopez11's avatar
    blopez11
    9 years ago

    You likely need to use a date table, relate it to your data's datekey, then use the columns from the data table in your report axis, slicers, and possibly measures

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago

Just an update...I've definitely been able to locate the cause of the error.  The 2 sales channels are the smallest channels we have and they don't have sales every day...so when I toss them in the mix..dates are skipped.   I'm really struggling on this one.  Any help is greatly appreciated!!

  • blopez11's avatar
    blopez11
    Icon for Super User rankSuper User
    9 years ago

    You likely need to use a date table, relate it to your data's datekey, then use the columns from the data table in your report axis, slicers, and possibly measures

    • codyraptor's avatar
      codyraptor
      Icon for Resolver I rankResolver I
      9 years ago

      The date table was exactly it!!  Thanks!!