Forum Discussion

hwoehler's avatar
hwoehler
Helper I
6 years ago
Solved

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.  ...
Need Help
  • dax's avatar
    dax
    6 years ago

    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.

dax's avatar
dax
Community Support
6 years ago

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.