Lookup types relations

[narasimhuluk]

SQL code: 

select 

LookupRepairTypeAR.Description AS RepairType

from 

 RepairWorksOrder AS RWO

Left Join

dbo.GetLookupDescription_AR('Repair Types') AS LookupRepairTypeAR ON RWO.RepairTypeId = LookupRepairTypeAR.LookupReference

details : 

RWO table 1 : repair typeid 

9
12
2
2
14
22
2
22

Lookuptype table 2:  lookup typeId , description 

1 Repair Types
2 Domain
3 SOR Tables
4 Repair Trades

i need to get the description of depair types where lookup type id is 1 

result should be like i want: 

9    day repair 
12  lift repair
2    heating repair
2    heating repair
14  lift repair
22 water 
2  heating
22  water 

how to achive above result in power bi  ?

[narasimhuluk · Accepted solution]

1) thats how we are doing in sql to get repair type description .. as above sql query 

we dont have any table toget description of repair types 

[v-shex-msft · Accepted solution]

Hi @narasimhuluk,

According to your description, it seems like you are using the getlookupDescripiton table to search the detailed description of repair type. I'm not so sure for your data structures and relationships, please provide more detailed information about your scenario.

In addition, you can also try to use below calculate column formula to RWO table if it works: (I try convert your t-sql query to dax formula)

Desc =
LOOKUPVALUE (
    'GetLookupDescription_AR(Repair Types)'[Description],
    'GetLookupDescription_AR(Repair Types)'[LookupReference], RepairWorksOrder[repair typeid]
)

Regards,

Xiaoxin Sheng

[Anonymous]

I guess you have the two tables "repairs" and "repair type" in PBI? Are they linked via a relationship using the repair code?
If so you don't need to create any LEFT JOIN as it's implicit in the relationship.

[narasimhuluk · Accepted solution]

1) thats how we are doing in sql to get repair type description .. as above sql query 

we dont have any table toget description of repair types