PREVIOUSQUARTER returns blanks

[Anonymous]

Hi All,

I see other people have had this exact same question but so far none of them have been answered/explained.

The PREVIOUSQUARTER DAX is returning blanks for me.

This is my formula:

LQ Sales = CALCULATE(SUM('Sales Data'[Sales]),PREVIOUSQUARTER(DimDate[Date]))

Any help would be much appreicated, all my other time intelligence formulas work fine.

Thanks,

Maria

[Anonymous]

is your date table marked as such?

[Anonymous]

Hi @Anonymous,

Thanks for your suggesion.

Yes, my Date Table is marked as such.

Any other ideas?

Thanks,

Maria

[Anonymous]

not off the top of my  head. Any chance you can upload some sample data?