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/