Open in app
Sign inGet started
DAX Power BI: Using FILTER and CALCULATETABLE

DAX Power BI: Using FILTER and CALCULATETABLE

The basic difference between these functions is how they perform filtering. FILTER always calculates the first parameter first, and then…
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI: TOPN — Output maximum values in measure

DAX Power BI: TOPN — Output maximum values in measure

Let’s look at another table function of the DAX language — the TOPN function. It allows you to create a table in which you can display the…
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI: SELECTCOLUMNS — Selecting Columns from Tables

DAX Power BI: SELECTCOLUMNS — Selecting Columns from Tables

This function creates a table with selected columns from a given table or with columns based on DAX expressions for our data model
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI: Pivot table — number of customers by date

DAX Power BI: Pivot table — number of customers by date

For example, let’s calculate the average number of customers per day in the table orders
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI:CALCULATE — Context Changing

DAX Power BI:CALCULATE — Context Changing

Consider the task of adding a Total column for each customer for the Orders table
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI: EOMONTH — End of Month Sales Forecast

DAX Power BI: EOMONTH — End of Month Sales Forecast

We need to create a measure that calculates the sales forecast by the end of the month. In order to make forecasts, we will divide the…
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
DAX Power BI: DATESBETWEEN & DATESINPERIOD

DAX Power BI: DATESBETWEEN & DATESINPERIOD

With the DATESBETWEEN and DATESINPERIOD functions, you can limit a column of dates, or take specific periods.
Go to the profile of Andrei Khaidarov, Microsoft MVP, PhD
Andrei Khaidarov, Microsoft MVP, PhD
About Power PlatformLatest StoriesArchiveAbout MediumTermsPrivacyTeams