Label an account that falls within a range (Unrelated tables)

[Deez]

Hi All,

I have a possible challenge for you PowerBI experts!

I have 2 Unrelated tables,

1st table with a list of accounts:

2nd UNRELATED table with a range of accounts with a description that I would like to join onto the above table as a new field : Description

My end result is to look like this with a Description against each account:

Any ideas?

Just a note: Its my first project using PowerBI so I fall into the dummy category.

Please provide as much detail as you can.

Best regards.

Deez

[v-yulgu-msft · Accepted solution]

Hi @Deez ,

Create a calculated table.

Result_Table =
VAR temp =
    FILTER (
        CROSSJOIN ( VALUES ( '1st'[Account] ), '2nd' ),
        '1st'[Account] >= '2nd'[DIMENSION FROM]
            && '1st'[Account] <= '2nd'[DIMENSION TO]
    )
RETURN
    SELECTCOLUMNS ( temp, "Account", [Account], "DESCRIPTION", [DESCRIPTION] )

Best regards,

Yuliana Gu

[Deez]

Hi @v-yulgu-msft,

That worked perfectly! Many thanks!

Regards,

Deez