Forum Discussion

FJ2017's avatar
FJ2017
Regular Visitor
2 years ago
Solved

Calculate column value based on reference table in another table

Gday all. I have been using this formula in excel but would like switch over to power BI and use it there instead. Basically it will check in a reference table to match the values from 2 columns ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

    Thanks for the solution ManuelBolz  provided, and i  want to offer some more infotmation for user to refet to.

    hello FJ2017 , you can create a calculated column in data table.

    Column =
MAXX (
    FILTER (
        'Lookup_table',
        [Siza(sq.m)] <= EARLIER ( 'Table'[Size(sq.m)] )
            && [Type] = EARLIER ( 'Table'[Property Type] )
    ),
    [Size Category]
)

    Ouptut

     

    Best Regards!

    Yolo Zhu

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

    Calculate column value based on reference table in another table.pbix31 KB
ManuelBolz's avatar
ManuelBolz
Responsive Resident
2 years ago

Hello FJ2017,

without a piece of data it is very difficult to help you. But basically I would say that it can be implemented with Power Query.


Best regards from Germany
Manuel Bolz

🤝Follow me on LinkedIn