Forum Discussion
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]);
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?
If you remove the non-related "Date" field from the table, does it show up?
4 Replies
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
If you remove the non-related "Date" field from the table, does it show up?