Forum Discussion
Helper IIICascade Quarterly targets to Monthly, Weekly in PowerQuery
Hello lovely people,
I have this structure for quarterly targets. I would like to split those targets per quarter to month (Jan/Feb/March for Q1, etc)
And also potentially by week / by day to compare progress at that level.
| Region | Q1 | Q2 | Q3 | Q4 |
| AAA | 10 | 15 | 24 | 40 |
| BBBB | 8 | 13 | 15 | 33 |
| CCC | 20 | 31 | 23 | 55 |
| DDDD | 4 | 6 | 5 | 12 |
So far I have split manually each quarter by month = January = Q1/3 etc but this is not really scalable.
Any help achieving this in Power Query?
Output would be something like, ideally possible to go to the week level?
Thanks a lot
| Region | Date | Value |
| AAA | Jan | 3.3 |
| AAA | Feb | 3.3 |
| AAA | March | 3.3 |
| AAA | April | 5.0 |
| AAA | May | 5.0 |
| AAA | June | 5.0 |
3 Replies
- amitchandak
Super User
qmartiny , You have to unpivot the data and create a date range and you can use the solution in a blog or file
- qmartiny
Hi Amit,
Seems to work thank you. However I would like to achieve it in PowerQuery since I want to create a relationship with other tables - it works in isolation but not with the rest Hi qmartiny ,
Did you solve your question and if so do you mind sharing it here and marking it as the correct answer to help more users with similar needs to you find it faster?
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
