Error Handling in Power Query

Hopefully, this blog will quickly become outmoded and useless and I will have wasted my time. Error handling in the Power Query Formula Language, most often simply called “M”, is weak compared with most modern programming environments, and the developers at Microsoft will no doubt address these issues and provide a better system. But, for […]
Read More ›

Creating Functions in M, The Power Query Formula Language

You have to be careful with economic data (with economists, too, but that’s an entirely different story). Is the data seasonally adjusted? Do the numbers represent current values or have they been adjusted to reflect the dollar’s average value in 2010? For such reasons, it is not uncommon for economists to annotate tables of data. […]
Read More ›

How Does Power BI Fit Into My Business Intelligence Plans?

Things change pretty fast in the business intelligence arena. Terms can change pretty fast, too. A little more than a year ago, many people used the phrase “Power BI” to refer to Excel Add-Ins of particular interest in BI, notably Power Pivot and Power Query. Now, the same phrase refers to a distinct and separate […]
Read More ›

Creating Excel Pivot Tables from Power BI Report Data

One thing that Microsoft has always done well is get its wide variety of services and applications to work together seamlessly (well, relatively seamlessly at any rate). We have previously looked at Power BI and noted that Power BI exploits the same in-database Analysis Services engine that powers the Excel Power Pivot data model. Many […]
Read More ›

Excel 2016: DAX Variables

  DAX Variables Well, DAX variables weren’t actually introduced with Excel 2016; they weren’t even introduced in 2016. Come to think of it, DAX variables aren’t even variables. Nevertheless, DAX variables are one of the most interesting and exciting recent additions to DAX. DAX variables were introduced to the Power Pivot engine in 2015, so […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.