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?

     

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.