Forum Discussion
undefined
Hi there no embed a formula in a lookupvalue need help with the dax sum amounts in a column if product id matches thanks
Powerbiji99 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
if you need
//Copy data from one table to another - with related 1-M, Copy on M side
Item Name = RELATED('item'[Brand])
//no realtion needed 1-M
Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])
Copy City without using related 1 - M
City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])
Copy City without using related M -1
City Name = sumx(FILTER(sales,geography[City Id]=Sales[City Id]),sales[amount])
Appreciate your Kudos.