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

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:  

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

Helpful resources

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