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.
Hey All,
Need help creating dax formula or calculated column to extract product density. Any help is greatly appreciated!
Need to go from left product column to right density group:
Product | Density |
A123 B1234 8Gbit 8 77/999 AE 1 AB | 8Gbit |
A123 B12 4Gbit 16 7/999 ABCDE 1 AB | 4Gbit |
A123 B1 2Gbit 16 77/999 AB 1 AB | 2Gbit |
A123 B12346 512Gbit 8 77/99 ABCDE | 512Gbit |
A123 B123 77/999 ABCDE 1TB | 1TB |
Thanks in advance!
Solved! Go to Solution.
Hi @asalazarjr
Try this code to add a new calculated column:
Column =
VAR _G =
FIND ( "Gbit", [Product],, -1 )
VAR _T =
FIND ( "TB", [Product],, -2 )
RETURN
IF (
_G <> -1,
RIGHT ( LEFT ( 'Table'[Product], _G + 4 ), 6 ),
IF ( _T <> -2, RIGHT ( LEFT ( 'Table'[Product], _T + 1 ), 3 ), "" )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @asalazarjr
Try this code to add a new calculated column:
Column =
VAR _G =
FIND ( "Gbit", [Product],, -1 )
VAR _T =
FIND ( "TB", [Product],, -2 )
RETURN
IF (
_G <> -1,
RIGHT ( LEFT ( 'Table'[Product], _G + 4 ), 6 ),
IF ( _T <> -2, RIGHT ( LEFT ( 'Table'[Product], _T + 1 ), 3 ), "" )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
You can add a custom column with this expression in the query editor. Note that M is case sensitive, so you can add in Text.Upper or Text.Lower to avoid that issue if needed.
= List.Select(Text.Split([Product], " "), each Text.Contains(_, "Gb") or Text.Contains(_, "TB")){0}
Pat
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |