Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return Value from other column

Hey, Can you help me with this problem that I face here?   I have two tables as shown below:   any idea how to get value as the expected column?   thank you  
Need Help
Show and Tell
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, you may create a measure as below.

     

    Pricing Value = 
var _date = SELECTEDVALUE(Takeup[Date])
var _type = SELECTEDVALUE(Takeup[Type])
return
CALCULATE(
    AVERAGE(Pricing[Value]),
    FILTER(
        ALLSELECTED(Pricing),
        Pricing[Date] = _date&&
        Pricing[Type] = _type
    )
)

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

If you take Simply the Avg or Value and expected it will work in visuals


In pricing table
new column Expected= if(Table[Type]="A",5, if (Table[Type]="B",10,15))

New Table =
summarize(Table,Table[ID],Table[Type],"Take up value",Max(Table[Expected]),"Expected",max(Table[Expected]))