Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Expert,
I hope you can help me with this request.
I have a file with two amount by month for each code of product:
a) The first amount is the monthly sales and
B) The second amount is the accumulated by month.
Something like this:
code | Description | Jan | Acum Jan | Feb | Acum Feb | Mar | acum Mar | Apr | Acum Apr |
AA | Code Red | 500 | 500 | 758 | 1,258 | 996 | 2,254 | 1,509 | 3,763 |
AB | Code Green | 750 | 750 | 1,137 | 1,887 | 1,496 | 3,383 | 2,268 | 5,651 |
AC | Code Blue | 1,200 | 1,200 | 1,800 | 3,000 | 2,340 | 5,340 | 3,510 | 8,850 |
I need convert the file and unpivot the amounts columns to generate two columns of amounts by month.
Something like this:
code | Description | Month | Monthly Amt | Acumulated Amt |
AA | Code Red | JAN | 500 | 500 |
AA | Code Red | FEB | 758 | 1,258 |
AA | Code Red | MAR | 996 | 2,254 |
AB | Code Green | JAN | 750 | 750 |
AB | Code Green | FEB | 1,137 | 1,887 |
AB | Code Green | MAR | 1,496 | 3,383 |
AC | Code Blue | JAN | 1,200 | 1,200 |
AC | Code Blue | FEB | 1,800 | 3,000 |
AC | Code Blue | MAR | 2,340 | 5,340 |
Is it possible?
Thanks in advance
Regards
Solved! Go to Solution.
Hi @gomezc73
Please find the attached PBIX file.
I have used month sort to match your expected data, you can ignore those steps
Please check the Power Query steps
Proud to be a Super User! | |
Hi @gomezc73
Please find the attached PBIX file.
I have used month sort to match your expected data, you can ignore those steps
Please check the Power Query steps
Proud to be a Super User! | |
I tried repeating all the steps and it worked perfectly. Thank you very much. You are the best.
thank you so much for your early response.
Can you send me the steps, how Pivot the data?. i can't find the option to do that.