Most data problems in Power Query can be solved using the UI, and even more can be resolved by slightly editing the M code generated by the UI. Thus, if your data is not excessively messy and your transformations aren’t too intricate, you may not require extensive M knowledge. However, if you invest time in learning M, you can unlock incredible possibilities!
Learning M language is going to be advantageous for anyone who works with data and wants to efficiently manipulate, clean and transform large and complex data sets. In this video, Brian is going to demonstrate exactly why that is the case, featuring an impressive solution by Alexis Olson in one of Excel BI’s recent challenges wherein he was able to automate the comparison of your data against online lists and references.
*****Video Details*****
00:00 Introduction
00:35 The challenge
01:06 Brian’s solution
02:14 Alexis’ solution
02:50 Adding emirps list
04:35 IsEmirp column
06:06 Filtering TRUEs
***** Related Links *****
Excel BI Challenge 170 – https://bit.ly/3ofIdK2
Alexis Olson’s Solution – https://bit.ly/43Bv4uZ
Integer Sequences Encyclopedia – https://oeis.org/
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial #M #MTutorial