cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hwoehler Helper I
Helper I

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)

DateGroupValueColumn1Column2
Monday, January 01,2020A22 
Tuesday, January 02,2020A5  

Wednesday, January 03, 2020

A6  

Friday, January 05,2020

A20  

Monday,January 08,2020

A332

Monday, January 15,2020

A113

Wednesday, January 17,2020

A6  

Friday, January 19,2020

A41  

Monday, January 22,2020

A14141

 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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Get weekly values and previous values

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.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Get weekly values and previous values

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.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors