Empty result previousmonth

[Anonymous]

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]);
FILTER (
ALL ('StoredProcedure');'StoredProcedure'[FirstDayOfMonth] = PREVIOUSMONTH('Date'[Date])
)
)

Notes:

'Date'[Date] is a single value from a created timetable. 

part of the datamodel looks like this:

FirstDayOfMonth	CustomerId	Price	Date
2018-02-01 00:00:00.000	11478	80	2018-02-01 00:00:00.000
2018-02-01 00:00:00.000	11478	129	2018-02-01 00:00:00.000
2018-02-01 00:00:00.000	11478	128	2018-02-01 00:00:00.000
2018-02-01 00:00:00.000	11478	249	2018-02-01 00:00:00.000
2018-03-01 00:00:00.000	11478	249	2018-03-01 00:00:00.000
2018-03-01 00:00:00.000	11478	128	2018-03-01 00:00:00.000

Anyone an idea of what i'm doing wrong?

[dedelman_clng]

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]

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

Result is the same, previous month stays empty. 

[dedelman_clng · Accepted solution]

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

[Anonymous]

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

It works now.