Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Week over week % change

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)

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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