Forum Discussion
Conditional unpivoting date columns in power query
I have multiple Excel files containing unit forecasts for different weeks ahead. For each week, a new Excel file containing new generated weekly forecasts (different number of week column compare to ...
This works perfectly well. Download from here...
https://drive.google.com/drive/folders/1fkjomtnrIDO0AFYm_X081mkRTgDvYbPn?usp=sharing
Here is the dataset. I had to manipulate the data since it is confidential. The column names remain the same, only the row data changed. Basically, I need to create a dashboard to calculate the changes of forecasted unit between the same dates for different files generated every week. Really appreciate if you can help. Thank you.
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalThis works perfectly well. Download from here...