Forum Discussion

dalacarelia's avatar
dalacarelia
Frequent Visitor
4 years ago
Solved

Lookup Table using filter to wiev average mesaure

Hello i realy need a bump with the logic in Power BI , I have table with average numbers with groupnames  Databse with te details is        I my mind i have to create a new column...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    new column
    AvgRent = LOOKUPVALUE(AVGGroup[AvgRent], AVGGroup[Group], DB[Group])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

new column
AvgRent = LOOKUPVALUE(AVGGroup[AvgRent], AVGGroup[Group], DB[Group])

dalacarelia's avatar
dalacarelia
Frequent Visitor
4 years ago

Thank you sir 
This is very good and helpful 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    If this post helps, then please consider Accept it as the solution, thank you!