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.

FJ2017's avatar
FJ2017
Regular Visitor
2 years ago

Dear Manuel

 

Thanks for offering your help on this.  I attach som example data to explain the expected function.

Does this help ?

 

Regards

Anonymous's avatar
Anonymous
Not applicable
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.

  • FJ2017's avatar
    FJ2017
    Regular Visitor
    2 years ago

    Thanks Anonymous , this worked perfect in it's most simple way without extensive coding.  Much appreciated and have a nice day.