Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Solved! Go to Solution.
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
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
Thanks for this!!
User | Count |
---|---|
84 | |
77 | |
64 | |
51 | |
46 |
User | Count |
---|---|
101 | |
43 | |
39 | |
39 | |
36 |