In this Video i show you how to extract a Fixed Pattern from a Dataset
#dataanalytics #data #datatransformation #etl #powerbi #powerquery #mquery #excel #exceltips
File
https://github.com/jbotes/powerbiTuto...
M Query Book
https://www.amazon.com/DefinitiveGui...
Noteworthy techniques
Custom Function
Functions Used
Text.Remove
https://powerquery.how/textremove/
list.select
https://powerquery.how/listselect/
text.split
https://powerquery.how/textsplit/
text.length
https://powerquery.how/textlength/