Week over week % change

[Anonymous]

Hi All,

I want to show WoW% change in my below graph with a line.

I tried by using the below measure but its not working properly, eg the % change from increase from week 44 to 45 but its decreasing here.

Kindly suggest what is wrong in the calculation.

Measure =

VAR _previousWeek = MIN( F_MARKETING_RESPONSE[FISCAL_WEEK] ) - 1

VAR lastWeekMQR =

    CALCULATE (

        [MQRs],

        FILTER (

            ALL ( F_MARKETING_RESPONSE ),

            F_MARKETING_RESPONSE[FISCAL_WEEK] = _previousWeek

        )

    )

RETURN

    DIVIDE([MQRs]-lastWeekMQR,lastWeekMQR,0)

[amitchandak]

@Anonymous , Create a separate  date or week table with rank on week/ year week

COlumn

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s