Use PreviousQuarter<dates> then the result displays "Blank"

Question

In the Analysis Services tutorial, I used the formula Internet Previous Quarter Margin:=CALCULATE([Internet Total Margin],PREVIOUSQUARTER('Date'[Date])),and then the result is Internet Previous Quarter Margin: (blank).I totally follow the tutorial's step,I cannot figure out what's going on here. If someone meet this situation too? Or someone can give me some advice?

Each row in Date column likes "7/18/2005 12:00:00 AM",and in this column,there are different years.

            

Answer 1

Hi Spencer,

In DAX, the first argument in CALCULATE() function is same as a measure, which means it should be aggregation on column, so you need to use aggregation function (like SUM).

Internet Previous Quarter Margin:=CALCULATE(Sum([Internet Total Margin]),PREVIOUSQUARTER('Date'[Date]))

And make sure the dates in date column is continuous. Since it just show BLANK() instead of error, please also check if it contains data one quarter ago.

Regards,

---

Simon Hou
TechNet Community Support

Answer 2

Hi Spencer, 

I'm doing the same and facing the same issue. where you able to solve it? 

Thanks