Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am new to Power BI and need some help. I need to parse the left part of the column before the (-) but there are several fields where there is no dash. In these cases, I want it to parse the left part of the column before the (.) and if there is neither, I want it to give me the entire field. Any suggestions on how I can accomplish that?
Sample Data:
Solved! Go to Solution.
You didn't mention if you want the result in the same column or in a new column.
The query below includes both alternatives.
let Source = #table(type table[PART_ID = text],{{"12-3983.98u"},{"897.yfdwhv"},{"jhjkkjygw"}}), Added = Table.AddColumn(Source, "ParsedPart", each if Text.Contains([PART_ID],"-") then Text.BeforeDelimiter([PART_ID],"-") else Text.BeforeDelimiter([PART_ID],".")), Transformed = Table.TransformColumns(Added,{{"PART_ID", each if Text.Contains(_,"-") then Text.BeforeDelimiter(_,"-") else Text.BeforeDelimiter(_,".")}}) in Transformed
This is how step "Added" looks like in the Query Editor with the popup for adding a custom column:
You didn't mention if you want the result in the same column or in a new column.
The query below includes both alternatives.
let Source = #table(type table[PART_ID = text],{{"12-3983.98u"},{"897.yfdwhv"},{"jhjkkjygw"}}), Added = Table.AddColumn(Source, "ParsedPart", each if Text.Contains([PART_ID],"-") then Text.BeforeDelimiter([PART_ID],"-") else Text.BeforeDelimiter([PART_ID],".")), Transformed = Table.TransformColumns(Added,{{"PART_ID", each if Text.Contains(_,"-") then Text.BeforeDelimiter(_,"-") else Text.BeforeDelimiter(_,".")}}) in Transformed
This is how step "Added" looks like in the Query Editor with the popup for adding a custom column:
This is perfect! Thank you so much. I wanted them in the same column and the second options works great.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |