Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Comparing Changes from Current Report and Last Report with Text Values

Hello. I have a report which lists items on backorder each week. Each week is determined by a date column, and I use a relative date column to determine Current Report (Value of 0), and Previous Repo...
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous i'm not clear about yur requirement. do you want to see -1 (week) value compare (-2) week? Correct?

 

How B456 in relative week -1 is "New Backorder", it is in stock 

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you can add a column using following expression and then based on the condition you can get indicator

 

My Last Week Value = 
VAR maxRelativeWeek = CALCULATE( MAX( Table1[Relative Week] ) ) -1
VAR lastWeekValue = CALCULATE( MAX( Table1[Comment] ), ALLEXCEPT( Table1, Table1[Item] ), Table1[Relative Week] = maxRelativeWeek )
RETURN 
lastWeekValue