The SELECTCOLUMNS function simply takes some column/columns from another table and create a new table from them. For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple: Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) It is the new table name, column name in the new table, column name in the original Read More
Category: Power BI
How to Fix “Begins with”, “Ends With”, “Contains” Missing in Power Query Filter
If you use PowerQuery (if you don’t learn as quickly as possible), you may notice that in the filter, some of the options you want to use seem to be missing. So why is ‘ Begins with, Ends With, Contains ‘ missing from some PowerQuery filters? In the example below I want to remove any Read More
How to Do a Forecasting in Power BI
We now see a line graph like the one below. Head over the Visualization panel and under the list of icons, find the analytics icon as shown below. Scroll down the panel and find the “Forecast” section. Click on the down arrow to expand it if necessary. Next, click on “+Add” to add forecasting on Read More
How To Add A Button Using Bookmarks In Power BI
In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons, as shown in the below image. In this article, I will create a button using a bookmark. A bookmark is a very useful Read More
How to Add a Column with Fiscal Month or Fiscal Week Number Not Starting From Jan 1?
Part I – Fiscal Month Here is a potential solution assuming you have some kind of data table with a column called Value that has your dates in it: Create a “Standard Month” column using MONTH([Value]) For example, create a “Custom Month” column for the Fiscal month starting from April 1: Part II – Fiscal Read More
How to Optimize Performance in Power Query
Occasionally, organizations will need to address performance issues when running reports. Power BI provides the Performance Analyzer tool to help fix problems and streamline the process. Consider the scenario where you are building reports for the Sales team in your organization. You’ve imported your data, which is in several tables within the Sales team’s SQL Read More