Category Archives: Power Query

Data transformation with Power Query

Transform date input as “Excel-unrecognized” text string into date (number) usable by #Excel This is a continuation of the previous post – How to turn “1st January, 2017” into #Excel recognizable date?   …using Get & Transform (better known as #PowerQuery). Note: … Continue reading

Rate this:

Posted in Power Query | Tagged , | Leave a comment

[Guest Post] 5 things you should start doing with Power Query

This is a guest post by Puneet Gogia. Power Query is a revolution. It’s a (part of a) complete self-service BI tool which can help you in importing, connecting, shaping, cleaning and sharing your data with little efforts. It has … Continue reading

Rate this:

Posted in Power Query | Tagged | 11 Comments