Week on week change error

[bidataservices]

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?

[amitchandak]

@bidataservices , Make sure Stock_Age_Calendar is calendar/date table and marked as date table

check

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[bidataservices]

It is already marked as a date table.