Dec 26, 2022
How to deal with null in Power Query
One of the common Data Preparation questions Power BI and Excel Users ask is how to deal with null in Power Query. Do you delete them or replace them with zero? There isRead More
power query
Aug 26, 2021
Understanding Power BI Engine – Power Query
Power BI is more then what most think it is. Power BI is a collection of engines that all come together to provide business intelligence service, allowing users to Collect, Transform and VisualizeRead More
Jul 15, 2021
How to use Native SQL Queries on Excel Data with Power Query
Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability to push data transformation tasks to the data source level, rather than on PowerRead More
Sep 12, 2020
How To Create Calendar Tables With Power Query
If you thought DAX was the only way to bring Calendar Tables to life, you thought wrong. Power Query is not left behind in the fun and we are about to see howRead More
Aug 22, 2020
A Step By Step Guide To Creating A Custom Calendar Table In Power BI (Part 1)
First, why do you need a Calendar Table, also popularly referred to as Date Tables? All reports include dates; MONTHLY, YEARLY, QUARTERLY, etc. and nearly all data sets have date fields. To makeRead More
Apr 16, 2020
Hidden Power Query Keyboard Shortcuts & Functionalities
Subscribe To Our YouTube Channel We all like to use shortcuts in our daily usage of various programs. For some people it’s easy access to various programs operations that can not be easilyRead More
