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,

SamiTi's avatar
SamiTi
Frequent Visitor
8 years ago

Hi,

 

Test on new page.

 

Create and Select from dropdown. August 2018

 

Create Table chart:

-Customer 

-Sales measure.

-Sales Previous Month measure = July 2018.

 

Let me know if this helps

 

Thanks

Sam

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi SamiTi,

 

Thanks for replying. I don't really understand what you suggest me to try though, sorry.

Here's a screenshot of what my report looks like until now.

 

I don't want to have to apply a filter myself because my intention is to publish this report in the Power BI service and other users will daily consult it. So it has to calculate last month sales itself without my intervention.

 

Thanks again

Ben

  • SamiTi's avatar
    SamiTi
    Frequent Visitor
    8 years ago

    Hi Ben

     

    Add a slicer with  month year in order for measure to return Previous month value. 

     

    User will need to select Month from Slicer.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      It works !!!!!!!!

       

      I have been traveling on blogs since 3 days now...

       

      Thank you so much !!!!