Creating a calculated column from another look up table in a Star

[Anonymous]

I have this scenario of a fact table Shipment and 2 lookup tables Brand and euc_brand.

Note: Brand table is nothing but Distinct Brand column from Shipment table.

The requirement:  I need Dax for the following. 

Create a Calculated column (Report Friendly Brand Name) matching Friendly brand names from euc_Brand.   

If Brand in the Shipment table (or Brand table) does not have corresponding Friendly Brand Names in the euc_brand table, we display the Brand Name in the calc column, else we use the Friendly Brand Names  from euc_brand.

Calc column

Report Friendly brand name = Friendly brand names (from euc_brand), 

But,

If Friendly Brand Names in euc_brand for the brand = Null, then Report Friendly Brand Name = Brand (in Brand table) 

Here is the relayionship:

Thanks Community for your quick help.  

[v-luwang-msft]

Hi @Anonymous ,

Could you pls share your sample data and expect output result ,remember to remove confidential data.

Best Regards

Lucien

[Anonymous]

Here is dummy data with PBIX:

https://1drv.ms/u/s!AlMdRxAveLesgcMbakkZMCLacmOl-Q?e=7wiKq4

Expected Result: 

New column to be added to Brand table based on assocated Friendly Brand Names from euc_brand

Brand Table:

Brand	Report Friendly Brand Name
Milk	New Milk
Chocolate	New Chocolate
Garri	New Garri
Moinmoin	Moinmoin
Sugar	Sugar

[Anonymous]

I used a LookupValue function:

Report friendly brand names =

VAR _LookedUp =

LOOKUPVALUE(euc_brand[Friendly Brand Names],euc_brand[Brand Names],Brand[Brand])

RETURN

IF ( NOT ISBLANK ( _LookedUp), _LookedUp, Brand[Brand] )

Got the desired result: