Forum Discussion
Pivot table dates in multiple rows
Hello,
I thought that the data was visible in the pbix file, sorry for that
The thing is that I simplified my original table to facilitate the job and to make it easier to understand what I needed to do. So when I went back to my original table, with a couple of columns more, I dindnt know how to replicate the M code. Here is my original table:
Just to give a little more details, the table is a weekly production forecast, where
Line1, Line2 = Production Lines
SKU : Item
Description: Item description -> It can be omited from the table
Form: weight of the item - > It can be omited from the table
And for each day, the expected production quantity
I hope it help
Thank you all for helping me
Regards
Hi Anonymous ,
I think it will be difficult to modify multiple tables in the same sheet, you could try save them in the different sheets or convert them into pivot tables(make sure they have the same column name, type and data structure ), the you could invoke function to transform it easily in M code. Below is my sample and I change something in your sample. You also could refer to https://blog.crossjoin.co.uk/2018/07/09/power-bi-combine-multiple-excel-worksheets/ for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.