Week Over Week Percentage Changes

[jwesle]

Hello,

I have a table that stores a savings information for a worker by week (Columns are "Name", "Week Date", and "Savings").  I am able to display the data as follows:

Name	4/20/2019	5/4/2019	5/11/2019	5/18/2019
Larry	$187.20	$192.50	$187.40	$155.70
George	$254.60	$222.70	$255.10	$301.40
Bob	$188.60	$150.80	$120.40	$135.20
Wendy	$354.10	$401.20	$358.40	$311.50

I would like to calculate the week-over-week percentage changes for each worker and display in the following manner:

	4/20/2019	5/4/2019	5/11/2019	5/18/2019
Name	Savings	% Change	Savings	% Change	Savings	% Change	Savings	% Change
Larry	$187.20	N/A	$192.50	3%	$187.40	-3%	$155.70	-17%
George	$254.60	N/A	$222.70	-13%	$255.10	15%	$301.40	18%
Bob	$188.60	N/A	$150.80	-20%	$120.40	-20%	$135.20	12%
Wendy	$354.10	N/A	$401.20	13%	$358.40	-11%	$311.50	-13%

I'm having difficulty creating the measure needed for this. Any advice?

Thanks!

[TomMartens]

Hey,

maybe you are already aware of this article: https://www.daxpatterns.com/time-patterns/

This is a great start of date/time related calculations in Power BI.

Regards,

Tom