This is an article about how to do cumulative counting by group in Power Query.

Group your data according to dynamic measure results

It is always necessary to group consecutive dates before proceeding to the next step of calculation when we are at work, which can be resolved by using the DAX function or Power Query in Power BI Desktop.

Embed for your customers can get an access token without Power BI account. If the users in your company have no Power BI account or they do not want to sign in with Power BI account, you can choose Embed for your customers.

Power BI dataflows enable you to connect to, transform, combine, and distribute data for downstream analytics. Some users hope to monitor refresh history and status of dataflows so that they can make refresh plans for datasets that use these dataflows.

In this article, I will introduce three methods to get refresh history of Power BI dataflows.

This is a blog about the Anchor Time in Relative Time Filter and Slicer.

This is a blog about the steps between python process and M engine drops leading zeros.

This is a blog about Workaround to the problem in the dataflow – “We did not recognize the format of your first file”

This is a blog about incorrect Share Url when creating embed codes with Publish to web

This is a blog about how to batch crawling web page data

For Power BI users, a problem often encountered is that they want to put the measure on the axis, but find that it cannot be achieved. Especially beginners want to do this habitually. Below I will give an example to explain this problem.

Basic situation: After a period of merchandise sales, a group of sales representatives will face performance evaluation.

The article is about dynamic calculation of contract status based on the updated dataset.

This is blog about import JSON files from multiple URLs into Power BI Desktop and Dataflow.