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.
Hi community,
I want to achieve something simple but in power query I feel as if I am making way too compley. So after not finding anything on google I turn to you 🙂
Suppose I have loaded URLs into PowerQuery. Here a sample input:
.com/watch?t=606&v=rpcd-MEmzAc&ebc=ANyPxKo6RT9WxuEfw
I am now looking for a method to remove certain texts (above in bold):
.com/watch?v=rpcd-MEmzAc
t=606& (string starting with a t= and ending with an & or nothing)
&ebc=ANyPxKo6RT9WxuEfw (string starting with &ebc= and ending with an & or nothing)
I tried:
#"REMOVE" = Table.TransformColumns(#"PREVIOUS_STEP", {{"COLUMN_TO_REPLACE", each Text.Remove(_, Text.BetweenDelimiters(_, "t=", "&") ), type text}})
But in case the Parameter doesn't occur at all I will receive an error. It should only then replace the value if it is possible.
Solved! Go to Solution.
#"REMOVE" = Table.TransformColumns(#"PREVIOUS_STEP", {{"COLUMN_TO_REPLACE", each Text.Replace(_, Text.BetweenDelimiters(_, "t=", "&"), ""), type text}})
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
#"REMOVE" = Table.TransformColumns(#"PREVIOUS_STEP", {{"COLUMN_TO_REPLACE", each Text.Replace(_, Text.BetweenDelimiters(_, "t=", "&"), ""), type text}})
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi, I am using this function to replace elements within html tags in a text.
It seems that the function does not replace the text for all occurrences, but only for the first one it finds.
Is it my mistake on how I am applying it or should some modification be applied?
#"Rimosso contenuto span" = Table.TransformColumns(#"Rinominate colonne4", {{"Descrizione", each Text.Replace(_, Text.BetweenDelimiters(_, "<span", ">"), ""), type text}}),
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |