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

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