cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
V-pazhen-msft
Community Support
Community Support

Scenario:

Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.

Read more...

V-lianl-msft
Community Support
Community Support

We often use specific value, ranges or some text functions to apply filter on data table fields. In fact, we can also use character functions to achieve some custom filter effect. Here I want to share some scenario about these function usages. 

Read more...

V-pazhen-msft
Community Support
Community Support

Scenario

With my experience of using Power BI, many users want to insert a sum row into the data table instead of using the grand total feature in the table/matrix visual. However, Power BI does not support inputting rows into columns by DAX method. Therefore, I would like to introduce the way to insert rows in query editor with further extension of adding multiple rows to sum up the previous N days’ data. It is important to note that the method is only suitable if you would like to insert roles to the existing column. As the result, the date hierarchy would become invalid that may affect the creation of report, this is because adding the sum rows would change the column type from Date/Time to Text.

Read more...

V-pazhen-msft
Community Support
Community Support

 

Scenario: 

I would like to get only one max value for each student ID. For example, a company needs to examine each person's attendance and identify the arrival time for being late monthly, but for the clarity of the report, it is required that if there is a duplication of the arrival time for being late, only one is identified.

 

Another example is a sales company that needs to mark the maximum monthly sales of each salesperson on the sales sheet and display the data during meetings. At this time, the maximum sales are duplicated, and if they are all marked, it will affect the beauty of the whole report, so only one of the duplicated maximum values should be randomly marked.

Read more...

V-lianl-msft
Community Support
Community Support

This blog will focus on getting you to learn how to calculate group distribution using Power Query in Power BI. This training is a relatively easy one. We’ll provide a dataset containing product and value and our goal will be to design a histogram to better communicate insights on the product base. 

Read more...

yingyinr
Community Support
Community Support

Expand the continuous date interval (Excluding weekends and holidays)

 

Read more...

yingyinr
Community Support
Community Support

Extend the date range into a date list

Read more...

RicoZhou
Community Support
Community Support

This is a blog about how to get version history from SharePoint by API.

Read more...

V-pazhen-msft
Community Support
Community Support

Scenario:  

Each day or Each month, an excel file with new dates’ date will be added. The data structure is the same, only data is different. How to automatically obtain the data of a new file in power bi desktop?

Read more...

RicoZhou
Community Support
Community Support

This blog is about how to transform table in Power Query.

Read more...

V-lianl-msft
Community Support
Community Support

Sometimes we encounter a bunch of mixed strings, which contain various types of information, such as dates, numbers, currencies, etc. How to extract date/currency amount from such text strings?

Read more...

v-lili6-msft
Community Support
Community Support

This is a blog about how to fuzzy match the dirty data and horizontal display the corresponding table

Read more...

v-lionel-msft
Community Support
Community Support

Scenario:

In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single.

Read more...

V-lianl-msft
Community Support
Community Support

The basic navigation panel used by M query function can calculate with query table records and add different query steps into the query table. They were not suitable to handle some complex scenarios(e.g. apply some advanced operations with its result or interaction with its calculations contents).  

In this article, I would like to share some tips on nested functions to handle some general scenarios where some basic functions don’t work.

Read more...

v-alq-msft
Community Support
Community Support

The article is about Partial Grouping in Power Query.

 

Read more...

Helpful resources

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