Matching values between two columns on a single table

[alecjbeckett]

Hi All,

New to powerbi and all things Dax. I have a table below

Customer Ticket ID	Ticket Name	Problem ID	Problem Ticket Name
1	T2017.200
2	T2017.201
3	T2017.202
4	T2017.300
5	T2017.301
6	T2017.302
7	T2017.303	10
8	T2017.304	10
9	T2017.305	10
10	T2017.100
11	T2017.101	1
12	T2017.102	1
13	T2017.103	4
14	T2017.104	4
15	T2017.105	4
16	T2017.106	4
17	T2017.107	4
18	T2017.108	4
19	T2017.109	4
20	T2017.110

Unfortunately our 3rd party's database has built it in this weird way so i am trying to find a way to report on a particular set of values.

Problem Ticket Name Column should be the formula which looks under Problem ID column and tries to see if there is a number associated. If it finds a number it then needs to see if it can find the corresponding number in Customer Ticket ID.

If it finds a matching number then i need it to copy the Ticket Name for that row into Problem Ticket Name column of the same row, if it cannot find a Problem ID or it is Blank it it should just leave the corresponding cell in Problem Ticket Name blank.

=IF(ISNA(VLOOKUP(C2,A:B,2,FALSE))=TRUE,"",VLOOKUP(C2,A:B,2,FALSE))

I built the query above in Excel which does the job but struggling to think how to do this in DAX. 

Any help would be greatly appreciated. Hope this makes sense!

Thanks!

[v-jiascu-msft · Accepted solution]

@alecjbeckett

Hi,

You can try this formula as a calculated column.

Problem Ticket Name =
LOOKUPVALUE (
    Table1[Ticket Name],
    Table1[Customer Ticket ID], 'Table1'[Problem ID]
)

Best Regards!

Dale

[alecjbeckett]

Thanks for this!!