Week over week percent change

[BrianJ]

@richmont,

This video will get you 95% of the way there:

Calculate Previous Weeks Sales - Advanced DAX in Power BI

From that point, you’ll just need to create a simple measure:

Pct Change =
DIVIDE(
	CurrentValue- PreviousValue,
	PreviousValue
)

If you care only about the magnitude of the change, not the direction (which your post above seems to imply, just add the following:

Pct Change =
    DIVIDE(
    	ABS( CurrentValue- PreviousValue) ,
    	PreviousValue
    )

I hope that’s helpful.

• Brian