Look Up Table

[Blkbrum35]

Hi All,

I am new to Power BI.... I am in need of your assistance. I have a table that I am trying to vlookup against in order to pick up the LOS Band where there is a match against a LOS field. So, where the LOS is greater than 2 it should still show "1-5" in the field.

LOS	LOS Band
1	< 1
5	1-5
10	6-10
15	11-15
20	16-20
25	21-25
30	26-30
35	31-35
40	36-40
41	> 40

Thanks in advance...

Dee

[v-sihou-msft · Accepted solution]

@Blkbrum35

I'm still not quite clear about your question. If you want to get the LOS Band, you can directly add a calculated column with SWITCH() function to specify each "bucket". 

=
SWITCH (
    TRUE (),
    Table[LOS] < 1, "<1",
    Table[LOS] >= 1
        && Table[LOS] < 5, "1-5",
    ...
)

Regards,