Forum Discussion
add dynamic row values from another table
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
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
Hi Jimmy801 ,
I just have calculated column NetSales1 and NetSales2 as shown in below fig.
I have calculated this using a lookup table
NetSales1 = Quantity1 * Rate1
Using Power Query, I am not able to get the NetSales1 as a row as shown below. Please advise on this.Hello Anonymous
just substitute the GetQuantityList with this code
GetQuantityList = List.Select ( Table.ColumnNames ( Combine ), each Text.Contains ( Text.Lower ( _ ), "quantity" ) or Text.Contains ( Text.Lower ( _ ), "netsales" ) ),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