The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all.
Need to Create a new column in power query with this SQL Statement
(TEXTO not like '%ORD 9%' and TEXTO not like '%ORD 6%' and TEXTO not like '%Reclassificação%' and TEXTO not like '%TRANSITORIA%' and(TEXTO <> '' or TEXTO_CAB like '%tarifa%'))
I tried this, but it did not work
if
List.AllTrue({
not Text.Contains([TEXTO], "ORD 9"),
not Text.Contains([TEXTO], "ORD 6"),
not Text.Contains([TEXTO], "Reclassificação"),
not Text.Contains([TEXTO], " "),
not Text.Contains([TEXTO], "TRANSITORIA"),
List.AnyTrue({
[TEXTO] <> "",
Text.Contains([TEXTO_CAB], "tarifa")
}),
})
then "True"
else "False"
Solved! Go to Solution.
@Anonymous wrote:
Can you show me how to create this column?
@Anonymous
You can just add a custom column via the UI if you don't know how to edit in the advanced editor. @Greg_Deckler's solution actually works in my test, when you say it doesn't work, could you be more specific?
Try this:
#"Added Conditional Column1" = Table.AddColumn(#"Unpivoted Columns", "Custom1", each if List.AllTrue({ not Text.Contains([TEXTO], "ORD 9"), not Text.Contains([TEXTO], "ORD 6"), not Text.Contains([TEXTO], "Reclassificação"), not Text.Contains([TEXTO], " "), not Text.Contains([TEXTO], "TRANSITORIA"), List.AnyTrue({ [TEXTO] <> "", Text.Contains([TEXTO_CAB], "tarifa") }) }) then "True" else "False")
Don't worked
Can you show me how to create this column?
@Anonymous wrote:
Can you show me how to create this column?
@Anonymous
You can just add a custom column via the UI if you don't know how to edit in the advanced editor. @Greg_Deckler's solution actually works in my test, when you say it doesn't work, could you be more specific?
Thank you, But don't worked =/
I did not understand how to do this column, is not it an ordinary column?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
128 | |
119 | |
82 | |
78 |