M_0 to M_11 are months. M_0 is present month (March 2021) and M_11 is present plus 11 months (February 2022). Columns names can be 0 to 11 or 1 to 12....
I have one more issue. I have two data warehouse tables: SALES, 140 variables, 10 years, 12+ mln rows and ORDERS, 60 variables, 10 years, 12mln+ ro...
It looks like I have to do pivoting almost exactly opposite to what you do in the Example 1. form the video on unpivoting data with Power Query. L.
Thank you for the reply. I uploaded the file. Will watch the video.
We are using it exactly as showed in sample Excel file I've send. The only difference is number of products (and time series) - over 5000 instead of m...
Thank you Mandy. It is useful. The issue is I have over 5000 products. Not sure if over 5000 buttons is the best solution :-|. Luke