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.
Hello everyone, forum noob here.
Someone can give me a tip on how to extract only the text (with accent) from that column:
The top 2 lines (number) (duration) will be useless for me, also in some cases the text can fill up to 2 rows instead of only one, like the example below
I am a power bi padawan yet.
Solved! Go to Solution.
I made a short video showing how to integrate M-code into your solution here: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Forum-Help-How-to-integrate-M-c...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @marcura ,
Could you try with this query :
let Source = YourTable,
#"Duplicated Column" = Table.DuplicateColumn(Source, "Mesclado", "Mesclado2"), #"Filtered Rows" = Table.SelectRows(#"Duplicated Column", each not Text.Contains([#"Mesclado2"], "->")), #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Mesclado2", type number}}), #"Kept Errors" = Table.SelectRowsWithErrors(#"Changed Type", {"Mesclado2"}), #"Removed Columns" = Table.RemoveColumns(#"Kept Errors",{"Mesclado2"}) in #"Removed Columns"
I already have this code:
let
Source = Csv.Document(File.Contents("C:\Users\João.Marçura\Downloads\Subtitles\[LilSubs.com]__Portuguese.txt"),[Delimiter="#(tab)", Columns=1, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Mesclado"}}),
#"Removed Blank Rows" = Table.SelectRows(#"Renamed Columns", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
#"Removed Blank Rows"
How can i integrate both? Also the column "Mesclado2" will generate from the code or it must be created before?
I made a short video showing how to integrate M-code into your solution here: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Forum-Help-How-to-integrate-M-c...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @marcura,
please define some rules which should filter out all unwanted lines. You know best your data. Then I can rewrite these rules in PQ.
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |