How to display selected and previous values

[RAKESH1986]

Hi all,

could you tell me what is wrong with my mesaure and how to dispaly current and previous values in dashboard.

i am trying to write a measure to dispaly -1 of selected values but getting below error.

I have these two tables.

table 1. 

Discipline, EARLY_PW_W, PW_EARLY_BASELINE

PIPING	PW01	0.02%
PROJECT MANAGEMENT	PW01	0.31%
PROCESS SAFETY	PW01	0.01%
MECHANICAL STATIC	PW01	0.01%
MECHANICAL ROTATING	PW01	0.01%
MECHANICAL HVAC	PW01	0.01%
TELECOMMUNICATION	PW01	0.01%
ELECTRICAL	PW01	0.03%
MATERIAL & CORROSION	PW01	0.02%
CIVIL & STRUCTURAL	PW01	0.02%
PIPELINE	PW01	0.02%
INSTRUMENTATION	PW01	0.03%
PROCESS	PW01	0.02%
INSTRUMENTATION	PW02	0.07%
MATERIAL & CORROSION	PW02	0.03%
MECHANICAL HVAC	PW02	0.02%
TELECOMMUNICATION	PW02	0.03%
PROJECT MANAGEMENT	PW02	1.14%
CIVIL & STRUCTURAL	PW02	0.05%
PIPING	PW02	0.05%
MECHANICAL ROTATING	PW02	0.03%
PROCESS SAFETY	PW02	0.03%
ELECTRICAL	PW02	0.05%
MECHANICAL STATIC	PW02	0.02%
PIPELINE	PW02	0.03%
PROCESS	PW02	0.06%

and another table linked to this with week no.

Progress_Data_Date,ProgressWeekNo,PW_Week_No

9/30/2022	1	PW01
10/7/2022	2	PW02
10/14/2022	3	PW03
10/21/2022	4	PW04
10/28/2022	5	PW05
11/4/2022	6	PW06
11/11/2022	7	PW07
11/18/2022	8	PW08
11/25/2022	9	PW09
12/2/2022	10	PW10

so whenver user select any week no it should display both selected and previous week no value..pls help me to get this.

thanks

rakesh

[RAKESH1986]

@AbbasG  thanks for the response. i removed the equal = sign still not working and getting below error.

I have no idea why it displays this value automatically, this field is not in my table but it still displays this field. and when I made this correct name, it display above listed error.

[AbbasG]

@RAKESH1986 EXPRESSION is missing in the CALCULATE, try re-writing the measure as below.

Measure = CALCULATE(
SUM('15_Early_PW_DISCIPLINE'[PW_EARLY_BASELINE],DataWeek[ProgessWeekNo]-1)

If not, please share sample data or pbix file to work on your problem (after removing all the sensitive information.)

[RAKESH1986]

@AbbasG  thanks for the updated query, measure is working now but it's not giving the correct result..

its value is fixed not changing while selecting the week. 

pbix file is available at this link

https://drive.google.com/drive/folders/1AL4lWng0rdfiEgNTMXHcfYueL6vXzwvO

pls help me to resolve this issue.

[AbbasG]

@RAKESH1986 you can use the calculated column, LOOKUPVALUE function to get the Progressweekno from dateweek table as below, and then use the new calculated column as a filter.

the filter then seems to be working.

[RAKESH1986]

@AbbasG thanks for the response.  it's working by using the lookup function but I have 10-12 tables and need to apply the same kind of filter. and by lookup way, I have to add in all tables, so want to know is there any other way to do it?

thanks

rakesh

[AbbasG]

@RAKESH1986 not sure, but remove the  = sign