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
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
JimmyNetSales row is not shown in the table. 😕
NetSales is a calculated column which is calculated by dax formula.Hello Anonymous
if netsales is part of your data, then is there. If you are adding this information only on Power BI as additional DAX column, then there is no way to have it here in Power Query. Then you need to add this information as new column in Power Query instead
BR
Jimmy