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,

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