Week Over Week Change %

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.