Forum Discussion

SHDJason's avatar
SHDJason
Icon for Advocate II rankAdvocate II
10 years ago
Solved

parallelperiod vs previousmonth vs adddate

Hi All,   I found a solution to this already but am confused about why it is so.     I need to find a simple previous month lookup.     Prev. Month Sales = CALCULATE(SUM([Total Sales]),DATEADD(...
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Hi SHDJason,

     

    In DAX, PARALLELPERIOD always returns full periods at the given granularity level instead of the partial periods that DATEADD returns. So please check if the dates in date column are continuous. If the dates in the current context do not form a contiguous interval, the function returns an error.

     

    Reference:
    PARALLELPERIOD Function (DAX)

     

    Regards,

  • SHDJason's avatar
    SHDJason
    Icon for Advocate II rankAdvocate II
    10 years ago

    Sean

     

    Yes i do have a calendar table. I tried using that and the date column in the data table. Both worked, but only for parallelperiod.  

     

    Is it possible that PowerBI caches the data and then does not always refresh? Sometimes, if I create a formula incorrectly then correct it, the new calculated values do not load. But if I refresh the dataset, they do load. I'm wondering if it is a cache issue. 

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Hi SHDJason,

       

      In DAX, PARALLELPERIOD always returns full periods at the given granularity level instead of the partial periods that DATEADD returns. So please check if the dates in date column are continuous. If the dates in the current context do not form a contiguous interval, the function returns an error.

       

      Reference:
      PARALLELPERIOD Function (DAX)

       

      Regards,

      • SamiTi's avatar
        SamiTi
        Frequent Visitor
        8 years ago

        Hi, 

         

        Above measure and functions are all working well as mentioned.

         

        However i cant see the Previousmonth sales BY category/store/product division all i get is "blank".

         

         

        screenshot Screenshot

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      SHDJason

      This is what I get with the Measures - numbered in the order you listed them (top to bottom)

       

      If you don't have a Month field though they'll either total OR

      as is the case with the 2nd Measure it will be blank because it doesn't have any reference month

       

       

      If you change a Measure it should immediately reflect that change - but that doesn't trigger data refresh.