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([Date]),-1,MONTH)) Prev. Month Sales = CALCULATE(SUM([Total Sales]),PREVIOUSMONTH([Date])) Prev. Month Sales = CALCULATE(SUM([Total Sales]),PARALLELPERIOD([Date],-1,MONTH)) The first 2 measures return null. The last one gives me the right answer. Why? Aren't these all the same? Thanks for your thoughts.

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,

parallelperiod vs previousmonth vs adddate | Microsoft Fabric Community

Forum Discussion

14 Replies

Related content