More on M

A recent post demonstrated the succinct and powerful quality of code native to Power Query. The original conundrum is highlighted in the Power BI forum here, and the posted solution no doubt works, but is a little cumbersome. The Power of M lies in it's human readability, which not only does not require encyclopaedic knowledge … Continue reading More on M

The Power of M…

...Power Query M WARNING: convoluted geek joke ahead Three data analysts walk into a bar, and the bartender gives them a problem: "My data table includes a column containing Company Name, but I want the business acronyms in a new column, with a space between each initial. Oh, and the data contains some hinky characters … Continue reading The Power of M…

Power BI: Making Data Pretty…

...and pretty understandable. Admit it: your business concurrently uses multiple legacy systems in multiple business areas -- whilst looking forward to the bright new shiny system you have commissioned -- and knitting all these data sources into a coherent ensemble presents a considerable reporting challenge. Power BI is a great way to render data meaningful … Continue reading Power BI: Making Data Pretty…