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 ›

Using Excel Power Query to Append a File to a Table

Lots of people import text-based files into Excel tables. Sonia V. recently asked if it was possible to append data imported from a text file to an existing table. I am not aware of any technique to do exactly what Sonia wants, but we can do the next best thing. We can read an Excel […]
Read More ›

How to Use Power Query to Import Hadoop Data into Excel

When Power Query was first introduced early in 2013 it was known as the Data Explorer. In some ways, Data Explorer was a better name. The primary job of Power Query is to enable Excel users to examine data, decide what values need to be imported into Excel, and then complete the import process. If […]
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.