Forum Discussion
add dynamic row values from another table
Sorry if my post is duplicated. I had searched the issue and found nowhere. Let me know if i can do this way or not. If I can do then, can you please me on this. I have 2 tables: Table1- ...
Hello Anonymous
change the AddedYear-step as follows
AddedYear = Table.AddColumn ( ChangeType, "Custom", each Date.Year ( [Date] ) ),
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi Jimmy801 ,
You are too good. If you dont mind, can you explain me from getQuantityList so that I can make few changes ?
Please...
Hello Anonymous
thank you 😁
what kind a changes you want to make?
This function defines which columns are unpivoted in the next step. The List.Select Function does a filtering of all column names and in the current setting it searches for items where quantitiy is a part of the item.
So the definition happens exactly here
Hope it helps
Jimmy