Forum Discussion

dhenders1833's avatar
dhenders1833
Frequent Visitor
2 years ago

DATEADD With Inconsistent Date Range

Hi All-   I have searched for days on YouTube and the web trying to find solve for the folllowing issue, and hope someone here can help.  I have the following dataset that includes sales by store f...
gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi dhenders1833 

 

Try using your date table in the DATEADD.

PY Revenue = CALCULATE( [Custom Sales], DATEADD( tbl_Date[Date], -365, DAY ) )
  • dhenders1833's avatar
    dhenders1833
    Frequent Visitor
    2 years ago

    Thanks for the recommendation, however that yields the same error as well.  It will allow me to pull into the visual alone, however when I pull in store number it then errors out.

    Without store #:

    With store #:

     

    • gmsamborn's avatar
      gmsamborn
      Super User
      2 years ago

      Hi dhenders1833 

       

      Can you replicate this problem with a small sample pbix?   (I've tried a couple of simple examples and mine seem to work as expected.)

       

      Also, can you double-check the error for your most recent example?  The previous error had to do with date tables in particular.

      • dhenders1833's avatar
        dhenders1833
        Frequent Visitor
        2 years ago

        Hi-

         

        Please see example at link below.  Essentially I am unable to get the PY measure to calculate properly.  If I use PARALLELPERIOD, it calculates however the amount is incorrect.  If I use DATEADD, it will not allow me to pull into the visual.

         

        I believe the issue it due to the fact that Store 202 does not have data for Apr 2024.  However in my actual dataset, I want the ability to still be able to calculate PY in spite of this, and I want to have a separate slicer that will allow the user to toggle between comp, non comp, and all stores.

         

        https://drive.google.com/file/d/1BZrWk8RtIcTZBRL5JiDrnO8cVCYT4O9t/view?usp=drive_link