Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Empty result previousmonth

Hi all,   I'm using the following measure in my report. I want to summarize the price of the previous month. The result stays empty.     PriceLastMonth = CALCULATE ( sum('StoredProcedure'[Price...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    If you remove the non-related "Date" field from the table, does it show up?

     

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

Please try this

 

PriceLastMonth = CALCULATE (
     sum('StoredProcedure'[Price]);
     PREVIOUSMONTH('StoredProcedure'[Date])  //<-- This should be the date column that has a relationship to the Date table
)

Hope that helps,

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi David, thnx for your reply. It didn't work. 

    Result is the same, previous month stays empty. 

    • dedelman_clng's avatar
      dedelman_clng
      Community Champion
      7 years ago

      If you remove the non-related "Date" field from the table, does it show up?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks David! The date field in the grid was the issue.

        It works now.