cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
ibarrau
Super User
Super User

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

Read more...

Poweraegg
Regular Visitor
Greg_Deckler
Super User
Super User

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

Read more...

Kumail
Post Prodigy
Post Prodigy

What new functions added in DAX during 2022

Read more...

Vijay_A_Verma
Super User
Super User

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

Vijay_A_Verma
Super User
Super User

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

 

Poweraegg
Regular Visitor
TedPattison
Microsoft
Microsoft

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.

Read more...

pade
Advocate III
Advocate III

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...

Screenshot 2023-01-17 180722.png

Read more...

KellyK
Administrator
Administrator

Learn about all the Power BI features released in 2022.  

Read more...

Vijay_A_Verma
Super User
Super User

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

 

Migasuke
Solution Sage
Solution Sage

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

 

Read more...

stevedep
Memorable Member
Memorable Member

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. 

Read more...

stevedep
Memorable Member
Memorable Member

This article is the first in a series. In these articles, we will predict occasion car prices (of Mitsibutsi Outlanders in the Netherlands). When you are able to predict car prices it helps to understand if a car has a relatively high or low price. Therefore, it supports decision-making when buying a car.

Read more...

amitchandak
Super User
Super User

How to get a formatted Profit and Loss statement with correct formatting, custom sub totals, and blank rows.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.