Forum Discussion
Pivot table dates in multiple rows
- 6 years ago
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
- Anonymous6 years agoNot applicable
Thanks camargos88 !
Awsome solution! besides I have learnt how to use Table.Group function. Thanks a lot.
Thank you very much dax too for your approach. I has been very useful!
Many thanks both!!