Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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 would like to create some criteria when extracting the text based on the number of "-" and the text of the column starting with "ABLE TO PLAY".
If the column starts with the text "ABLE TO PLAY" and the amount of ; "-" is greater than 1 so I want it to extract the text following this RULE:
Text.BetweenDelimiters([SPENDING LOCATION], "-", "-", 0, 1)
But if the number of "-" is less than or equal to 1 then I want it to use:
Text.AfterDelimiter([SPENDING LOCATION], " ", 2).
If the column starts with any text other than "ABLE TO PLAY" it can return the normal value of the column without change.
Solved! Go to Solution.
= Table.AddColumn(#"Renamed Columns", "Custom",
each if
Text.Length(Text.Select([_5],"-"))>1 and Text.StartsWith([_5],"ABLE TO PLAY")
then Text.BetweenDelimiters([_5], "-", "-", 0, 1)
else if
Text.Length(Text.Select([_5],"-"))<=1 and Text.StartsWith([_5], "ABLE TO PLAY")
then Text.AfterDelimiter([_5], " ", 2) else [_5])
Achieve after testing a lot! If anyone has the same problem or something similar I hope it helps.
= Table.AddColumn(#"Renamed Columns", "Custom",
each if
Text.Length(Text.Select([_5],"-"))>1 and Text.StartsWith([_5],"ABLE TO PLAY")
then Text.BetweenDelimiters([_5], "-", "-", 0, 1)
else if
Text.Length(Text.Select([_5],"-"))<=1 and Text.StartsWith([_5], "ABLE TO PLAY")
then Text.AfterDelimiter([_5], " ", 2) else [_5])
Achieve after testing a lot! If anyone has the same problem or something similar I hope it helps.
Hi,
Will you able to share some sample records?
Thanks
Hari
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |