Forum Discussion

narasimhuluk's avatar
narasimhuluk
Frequent Visitor
7 years ago
Solved

Lookup types relations

SQL code:  select  LookupRepairTypeAR.Description AS RepairType from   RepairWorksOrder AS RWO Left Join dbo.GetLookupDescription_AR('Repair Types') AS LookupRepairTypeAR ON RWO.RepairTypeId = ...
Need Help
Show and Tell
Tutorial Requests
  • narasimhuluk's avatar
    narasimhuluk
    7 years ago

    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 

     

  • Anonymous's avatar
    Anonymous
    7 years ago

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

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's avatar
narasimhuluk
Frequent Visitor
7 years ago

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