Forum Discussion

Powerbiji99's avatar
Powerbiji99
Frequent Visitor
5 years ago

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.