SUM/AVERAGE: can only aggregate numerical values

MAX/MIN: Text can be aggregated

DISTINCTCOUNT: Distinct counting

COUNTROWS: Count the number of rows in the table

COUNTROWS(VALUES()): Unrepeated counting

condition count

AVERAGE

AVERAGEX

Common writing method

Overall proportion

Group proportion

Overall relative proportion

Relative proportion of categories

external filter

ISINSCOPE

SWITCH( TRUE(), ISINSSCOPE('Product Table'[Product Name],[Relative Proportion of Category], ISINSSCOPE('Product Table'[Product Category],[Overall Relative Proportion], [overall relative proportion] )

Iteration function, the first parameter is the table, which is the row context

The fifth parameter can control ascending and descending order, the default is descending order'

absolute ranking

relative ranking

CROSSJOIN

RANKX( CROSSJOIN( ALL('product list'[product name]), ALL('Customer table'[Customer city]) ), [Sales] )

Top N names

Nth place

Non-TOPN products are aggregated into other items

Create new table

Create new column

IF function

customize

average value

Create a price grouping table

customize

average value

Revised total

frequency distribution

Static Pareto Analysis

Dynamic Pareto Analysis

the day before

last month

last quarter

More flexible way of writing

month-on-month

last year

last year

Month-on-year

year to date

last year year to date

Moving the total for a fixed time period

time intelligence function

Data correction

DAX

Create fiscal year and fiscal quarter date dimensions (calculated columns)

Same time last week

week to date

week-on-week

Make sure there are fields related to "week" in the date dimension table

Create an inactive relationship

Activating relationships using functions

Create a comparison date table (copy the original date table)

Compare the date table with the original date table to establish an inactive relationship, compare the date to filter the original date

The total is equal to the sum of the details one dimension

two dimensions

Missing dimension - complete dimension

Calculation result value blank - 0 after measure value

Calculation result text is blank-&&""

Excel import

Use "Enter Data"

DAX new table

Sort by column (corresponding to numeric columns)

ctrl wheel zoom in and out

shift enter to wrap and indent

alt enter newline without indentation

ctrl [/] cancel left/right indentation

alt ↑/↓ move the current line up/down

ctrl i selects the current line

shift ctrl enter insert a line above

ctrl shift k delete line

//comment symbol