Forum Discussion
Get weekly values and previous values
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
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.