Carl Wiberg
New Member
- Joined
- Oct 12, 2016
- Messages
- 6
Hi,
Looking for a way to retrieve the closing balance from the previous year but fail due to poor knowledge![Roll eyes :rolleyes: :rolleyes:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f644.png)
Simpy explained, for all months in the current year, I want to put the previous year's closing balance in a new column, for example named "Latest/December Value Last Year". Attaching a picture where columns A, B and C are my "report data" and column E is the output I would like to have in my Power Query.
Is there a "simple" and understandable way to solve this in Power Quesry and M?
Thanks in advance!
Looking for a way to retrieve the closing balance from the previous year but fail due to poor knowledge
![Roll eyes :rolleyes: :rolleyes:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f644.png)
Simpy explained, for all months in the current year, I want to put the previous year's closing balance in a new column, for example named "Latest/December Value Last Year". Attaching a picture where columns A, B and C are my "report data" and column E is the output I would like to have in my Power Query.
Is there a "simple" and understandable way to solve this in Power Quesry and M?
Thanks in advance!