Forum Discussion
Conditional unpivoting date columns in power query
This works perfectly well. Download from here...
Unfortunately, it comes with this error
Can you give me your Excel file with 2-3 lines of data? You can change the data if the data is confidential.
Please upload the file without confidential/sensitive data to a cloud storage service such as Onedrive/Google Drive/Dropbox/Box (Onedrive preferred) and share the link 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.
This works perfectly well. Download from here...