Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

PREVIOUSQUARTER returns blanks

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
 
3 REPLIES 3
Anonymous
Not applicable

is your date table marked as such?

How to Mark as Date Table.png

Anonymous
Not applicable

Hi @Anonymous,

 

Thanks for your suggesion.

Yes, my Date Table is marked as such.

Any other ideas?

 

Thanks,

Maria

 

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.