Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |