Thursday 8 April 2021

Type of DAX Function in Power BI

https://www.tutorialspoint.com/power_bi/dax_basics_in_power_bi.htm

DAX Functions

In Power BI, you can use different function types to analyze data, and create new columns and measures. It includes functions from different categories such as −

  • Aggregate
  • Text
  • Date
  • Logical
  • Counting
  • Information

Power BI provides an easy way to see the list of all functions. When you start typing your function in the formula bar, you can see the list of all functions starting with that alphabet.

Aggregate Functions

DAX has a number of aggregate functions.

  • MIN
  • MAX
  • Average
  • SUM
  • SUMX

Counting Functions

Other counting functions in DAX include −

  • DISTINCTCOUNT
  • COUNT
  • COUNTA
  • COUNTROWS
  • COUNTBLANK

Logical Functions

Following are the collection of Logical functions −

  • AND
  • OR
  • NOT
  • IF
  • IFERROR

TEXT Functions

  • REPLACE
  • SEARCH
  • UPPER
  • FIXED
  • CONCATENATE

DATE Functions

  • DATE
  • HOUR
  • WEEKDAY
  • NOW
  • EOMONTH

INFORMATION Functions

  • ISBLANK
  • ISNUMBER
  • ISTEXT
  • ISNONTEXT
  • ISERROR

DAX Calculation Types

In Power BI, you can create two primary calculations using DAX −

  • Calculated columns
  • Calculated measures

No comments:

Post a Comment