Power Query Editor (PQE) is a best tool available in Excel / Power BI / SSAS (SQL Server Analysis Services). PQE performs the ETL...

Some times you need to deal with Data in PDF Files. And you can't compute data within PDF, so you need to take that Data into Excel /...

Learn a simple trick to combine many CSV Files in a folder to a single Query Table in Power Query Editor. In Power BI / Excel, you can...

A most common Question I face from many Participants during my Training programs that , is there a possibility to compare Excel and Power...

The question posted in community.powerbi.com Is there a SAMEPERIOD LAST DAY equivalent in DAX? Hence August 1st to 15th versus July 1st...

This is a most common question asked across the Groups. How to Hide or Un-hide Sheets based on Selection. There are two ways One, by...

Creating PowerPoint is one big task while preparing for any Special events like Monthly/Quarterly Business Performance Meetings! It is my...

Microsoft Power Query provides a powerful data import and cleansing process experience While working with Power Query in Excel and Power...

Many times I have seen a question in many forums, how to Get Data from Google Sheets Interestingly , the process is quite simple and you...

When you are developing a report in Power BI, you always need special effects to make your report much interesting and readable and also...