Week Over Week Change %

[Anonymous]

Hello All,

Could anyone assist me in a week over week change measure please? 

the below doesnt seem to be working for me. 

Red Jobs WoW% =

IF(

    ISFILTERED('Open Job Report Tracker'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    VAR __PREV_WEEK =

        CALCULATE(

            SUM('Open Job Report Tracker'[Red Jobs]),

            DATEADD('Open Job Report Tracker'[Date].[Date], -7, DAY)

        )

    RETURN

        DIVIDE(

            SUM('Open Job Report Tracker'[Red Jobs]) - __PREV_WEEK,

            __PREV_WEEK

        )

)

Thanks, 

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure. 

Red Jobs WoW% = 
VAR __PREV_WEEK =CALCULATE(SUM('Open Job Report Tracker'[red jobs]),FILTER(ALL('Open Job Report Tracker'),'Open Job Report Tracker'[Date]=MAX('Open Job Report Tracker'[Date])-7))
var _b= DIVIDE(SUM('Open Job Report Tracker'[red jobs])-__PREV_WEEK,__PREV_WEEK,0)
return IF(
    ISFILTERED('Open Job Report Tracker'[Date]),
    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),_b)

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.