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 = 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
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
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

Forum Discussion