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 ›

Using Excel Power Query to Unpivot and Transform Data for SPSS Analysis of Variance

Excel, of course, is quite capable of providing simple statistical summaries and analyses. However, there are occasions when bigger guns must be brought to bear on a statistical problem, and Excel data must be exported to a dedicated statistical package such as IBM’s SPSS. Since SPSS can directly read Excel files, should be s simple […]
Read More ›

Type to search

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.