Get weekly values and previous values

[hwoehler]

Hello everyone,
I would like to display the values ​​of each Monday and those of the previous Monday for each Group (!) in two columns (Column1, Column2) so that I can then divide the two values. 

Expected Output: (in my real data, there is, of course, more than just one group A)

Date	Group	Value	Column1	Column2
Monday, January 01,2020	A	2	2
Tuesday, January 02,2020	A	5
Wednesday, January 03, 2020	A	6
Friday, January 05,2020	A	20
Monday,January 08,2020	A	3	3	2
Monday, January 15,2020	A	1	1	3
Wednesday, January 17,2020	A	6
Friday, January 19,2020	A	41
Monday, January 22,2020	A	14	14	1

 In my power bi file, there are already the columns Value, Group and Date, so I only need to compute the last two columns in order to calculate sth..
I am grateful for your help.

Regards, hwoehler

[dax · Accepted solution]

Hi @hwoehler ,

As I know, the 2020.1.1 is Wednesday, so I add a date column in your table, you could use actual date or use your sample logic to achieve this goal. You could refer to my sample for details.

Best Regards,
Zoe Zhi

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