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.
Inqueryeditor, you can use parameter as a filter option.
You can use parameters when defining connection properties.For example, if you retrieve data from SQL Server, you can use one parameter for the SQL Server instance and one parameter for the target database.And you can also use parameter to SQL queries by Value.NativeQuery().
You can create a new function from a query and reference parameters as the arguments of your custom function.
In this article, I will show you how to use column(the column can be obtained from other queries) as parameter to get data from API.