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.
I have a field called "Mail Back Type" that resides in a table called "v_rp005_rejectreport" and within this field there could be a varying number of code values stored (see screenshot). Is it possible using DAX to take those code values and convert them into descriptions, separated by commas? The key of what each code represents is also provided below.
I tried doing this myself but was getting hung up on the situations where multiple codes are present in the "Mail Back Type" field.
MLBR01 = Signature Not Matching With Name
MLBR02 = Primary Insured
MLBR03 = Missing Required Information
MLBR04 = Need Of Notarized Document
MLBR05 = Account Number Required
MLBR06 = Coverage Amount Required
MLBR07 = Multiple Coverage Amounts Selected
MLBR08 = Credit Card Number Required
MLBR09 = Signature Required
@krichmond , I think you have to use substitute multiple times in DAX
https://learn.microsoft.com/en-us/dax/substitute-function-dax
example
substitute(substitute([col1],"MLBR01","Signature Not Matching With Name"),"MLBR02","Primary Insured")
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 |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
67 | |
61 | |
46 | |
45 |