Forum Discussion

bidataservices's avatar
bidataservices
Frequent Visitor
3 years ago

Week on week change error

I have a table with dates, previous week value, current week value and week o week change value. I am trying to get week on week change % but cannot get it to work.

The measures I have are:

PreviousWeekValue =
VAR todaycost =CALCULATE(SUM(STOCK_AGING_BY_PARTNO[Value]),DATEADD(Stock_Age_Calendar[Date],0,DAY))
   
VAR LastWeek =
    CALCULATE (
        SUM ( STOCK_AGING_BY_PARTNO[Value] ),
        DATEADD(  Stock_Age_Calendar[Date],-7, DAY)
    )
RETURN
   LastWeek
 
 
CurrentWeekValue =
VAR todaycost =CALCULATE(SUM(STOCK_AGING_BY_PARTNO[Value]),DATEADD(Stock_Age_Calendar[Date],0,DAY))
   
VAR LastWeek =
    CALCULATE (
        SUM ( STOCK_AGING_BY_PARTNO[Value] ),
        DATEADD(  Stock_Age_Calendar[Date],-7, DAY)
    )
RETURN
   todaycost
 
 
Week_on_Week Change = [CurrentWeekValue] - [PreviousWeekValue]
 
Week_on_Week Change% = ([CurrentWeekValue] - [PreviousWeekValue])/[PreviousWeekValue]
 
All these work fine, except for the change%, which just returns NaN.
 
Can anybody throw some light on this please. What am I missing?
Need Help

2 Replies