Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Formula Returning Blank

I'm simply trying to capture the sum of revenue for the previous quarter. Is there any reason why this formula isn't returning anything at all?:  
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Your DAX is correct. Please drag year field or date field with the measure to table visual, otherwise you will get blank values.

    Regards,
    Lydia

  • Thejeswar's avatar
    Thejeswar
    8 years ago

    Hi Anonymous,

    As Anonymous mentioned, bringing in Year/ Date field to your visual should fix this

     

    Regards,

    Thejeswar

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

Hi Anonymous,

The Measure is to be written as follows

 

Previous Quarter Sales = CALCULATE(SUM(Sheet1[Sales Amount]), PREVIOUSQUARTER('Date'[Date]))

Here Sheet1 is your actual data and Date is a calendar table that has all the dates in the year/Quarter

These tables should be related by Date

 

Data screenshot:

Here 2018 has Q1 data and 2017 has Q4 data

Regards,

Thejeswar

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thejeswar There's gotta be something I'm missing. I've tried that and the formula just wants to be blank for some reason:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      Your DAX is correct. Please drag year field or date field with the measure to table visual, otherwise you will get blank values.

      Regards,
      Lydia

    • Thejeswar's avatar
      Thejeswar
      Icon for Super User rankSuper User
      8 years ago

      Hi Anonymous,

      As Anonymous mentioned, bringing in Year/ Date field to your visual should fix this

       

      Regards,

      Thejeswar