Previous Month vs. slicers/filters

[Anonymous]

Hi,

I've been dealing with this problem: I need to add previous month value to my dashboard, so I created measure Previous month value = CALCULATE ( [value], PARALLELPERIOD ( 'Date'[Date], -1, MONTH ) ) , but this doesn't work with slicers (see pic below).  I need to get the new measure into the same card with my other measures. Also banning the filter is not the option, because I need the users to be able to swich between months.

Thanks in advance for any help!

Zuzana

Example of my data:

YearMonth number	Previous month  value	Actual month value	Fiscal y/m
2016-08		$5,289	FY2016-08
2016-09	$5,289	$9,052	FY2016-09
2016-10	$9,052	$8,459	FY2017-10
2016-11	$8,459	$6,715	FY2017-11
2016-12	$6,715	$6,038	FY2017-12
2017-01	$6,038	$7,272	FY2017-01
2017-02	$7,272		FY2017-02

Example of what I'm getting, if I filter out just one month:

[Anonymous · Accepted solution]

Hi @Anonymous,

What is the data type of YearMonth number?


If it is text type, please firstly add an index column in your current table, then create a calculated column in your table using the formula below.

Previous Month VALUE = IF(
  Table[Actual month value] = 0,
  Table[Actual month value],
  LOOKUPVALUE(
   Table[Actual month value],
   Table[Index],
   Table[Index]-1)
 )

This way, when you create table visual and card visual using the newly created column. And you will be able to filter the visuals with slicers.

Thanks,
Lydia Zhang