?????????????????? ??????: ???????????????????? ?????? ?????????? ???? ?????????? ????'?? ???????? ???????????????? ??????????????????????"

????????????????????????

Power BI is a powerful data visualization and analysis tool that allows you to create interactive reports and dashboards. One of the key features of Power BI is the ability to create data models using the Data Analysis Expressions (DAX) language. DAX is a formula language used to create custom calculations and expressions in Power BI. In this blog post, we will explore the basics of writing DAX in Power BI.

???????????????? ?? ?????? ??????????????

Measures are calculations that are based on the values in a table. To create a new measure, you can right-click on the table in the Fields pane and select "New Measure" from the context menu. This will open the formula bar, where you can enter the DAX formula for your measure.

For example, let's say you have a sales table with columns for sales amount, cost, and profit. To create a new measure for the total sales amount, you would enter the following formula in the formula bar:

?????????? ?????????? = ??????(??????????[?????????? ????????????])

This formula uses the SUM function to add up the values in the Sales Amount column of the Sales table.

?????????? ?????????????????? ???? ??????

DAX includes a wide range of functions that you can use in your formulas. These functions can be used to perform calculations, manipulate text and dates, and filter data. Some commonly used DAX functions include:

??????: adds up the values in a column

??????????????: calculates the average of the values in a column

??????: finds the minimum value in a column

??????: finds the maximum value in a column

??????????: counts the number of rows in a table or column

????: performs a conditional test and returns one value if the test is true and another value if the test is false

For example, to create a new measure for the average sales amount, you could use the following formula:

?????????????? ?????????? = ??????????????(??????????[?????????? ????????????])

?????????????????? ???????? ???????? ??????

DAX includes a range of functions that you can use to filter data in your calculations. These functions include:

????????????: returns a table that meets a specified condition

??????????????????: evaluates an expression in a modified filter context

??????: removes filters from a table or column

????????: returns the top N rows from a table based on a specified sort order

For example, to create a new measure for the total sales amount for a specific region, you could use the following formula:

?????????? ?????????? ?????? ???????????? = ??????????????????(??????(??????????[?????????? ????????????]), ??????????[????????????] = "??????????")

This formula uses the CALCULATE function to evaluate the SUM function in the context of the North region.

????????????????????

In this article post, we have explored the basics of writing DAX formulas in Power BI. We have looked at how to create new measures, how to use DAX functions, and how to filter data using DAX. By mastering these techniques, you can create powerful calculations and expressions in Power BI that will help you gain insights into your data.