Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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-  ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jimmy801's avatar
    Jimmy801
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

NetSales row is not shown in the table.  ğŸ˜•


NetSales is a calculated column which is calculated by dax formula.

Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Jimmy801 ,

    Yes the netSales is calculated in power bi. Is there a way where i can calculate the column in power query.
    Can you give me a ref link or example where i can calculate from lookup table and use conditions in it ?

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hello Anonymous 

     

    the general microsoft site is a good starting point link.

    In your case check out the Table.NestedJoin-function. This function enables relationships between 2 tables. In case you have question, post a new question to the forum.

     

    All the best

     

    Jimmy