undefined

[Powerbiji99]

Hi there 

no embed a formula in a lookupvalue

need help with the dax

sum amounts in a column if product id matches 

thanks

[amitchandak]

@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.