Since February 2023 Power BI update, we have two new statistical functions LINEST() and LINESTX(). Using these functions we can easily create DAX measure to get the trend line.

This session examines how to automate tedious data modeling tasks by developing an external tool for Power BI Desktop using C#, the Tabular Object Model (TOM) and Visual Studio 2022.

After several years using Power Bi Desktop with many users I see that a bad practices are still implemented. At first I thought it was adjusted to the tool being new or inexperienced users. However, I'm thinking the reason is because of the lack of content about Power Query.

What I'm talking about is the bad habit of generating an enormous number of steps in the query editor to clean up data sources. Some time ago I found a short video of an Indian generating tips for the reduction of steps in Power Query which led me to think "I should generate content from this too".

This article will show some daily examples of Power Query to reduce the steps of our queries

Free Tutorial!

Your DAX calculated columns aren't the end of the world...

What new functions added in DAX during 2022

This can answer questions like - How many of our employees didn't participate in a conference.
A table contains the names of persons who enrolled to attend a conference. Another table contains the names of participants of the conference from different organizations.
We need to find from our organization who all didn't attend the conference.

The Excel file used in this can be downloaded from - https://1drv.ms/x/s!Akd5y6ruJhvhvyiKR16pp0AxtQT_?e=gjQWKB

In data processing, you may be required to remove rows and columns which contains only null. They won't add any value to data analysis.

Learn to remove blank rows and columns in Power Query from your data set.

The Excel file used in this can be downloaded from - https://1drv.ms/x/s!Akd5y6ruJhvhvySRn_3JtSEjiHoy?e=mi60gP

It just got easier to build multi-language reports for Power BI. Join us for the January session of Power BI Dev Camp and learn about new enhancements to Power BI which make it much easier to add support for secondary languages. We'll review what those changes are and we'll teach campers an approach for creating a reliable end-to-end process for extending Power BI reports to with multi-language capabilities.

Query Folding are fundamental for an efficient ETL and while working with Power Query Editor you must push the steps that breaks Query Folding to the end. Or do you… If curious, please continue reading...

Learn about all the Power BI features released in 2022.  

Learn to perform exact match in Power Query like XLOOKUP, VLOOKUP in Excel.

The pbix file used in this can be downloaded from - https://1drv.ms/u/s!Akd5y6ruJhvhvwxUuHqOA1XAZ33u?e=8ZDAik

Have you ever tried to combine multiple Excel files from a folder? Probably you experienced the same issue, which I explain my blog.

This article is a follow-up to the first article where we created a visual from scratch. The approach that we used was very straightforward, we directly used the data interfaces without using any typing. In this article, we will add typed data interfaces.