May 22, 2022
  • Facebook
  • Twitter
  • Youtube
Expert-Only

  • Database
    • Create database with SQL Server Management Studio
    • Create SQL database with a script
    • Drop SQL Server database script
  • Tables & views
    • Table
      • Create SQL Server table
      • Create table with primary key
      • Create customer table
      • Alter SQL table
      • Truncate SQL Server table
      • Drop SQL table
      • Check if SQL table exists
    • View
      • Create SQL Server view
      • Alter SQL view
      • Drop SQL view
      • Create SQL partitioned view
  • Procedure & functions
    • Procedure
      • Create stored procedure
      • Alter stored procedure
      • Create procedure with parameters
    • Function
      • Manage SQL function
      • Create SQL function
      • Call SQL function
      • Alter SQL function
      • Delete SQL function
  • Indexes & partitions
    • Index
      • Clustered SQL index definition
      • Create SQL index
      • Rebuild SQL index
      • Reorganize SQL index
      • Disable SQL index
      • Drop SQL index
      • List all SQL indexes
    • Partition
      • SQL Server partition definition
      • Create SQL table partition
  • MS Office tips
    • Excel tips
      • Best cell selection shortcuts for Excel
      • Display the day in all letters with Excel
      • Excel shortcut to select an entire column
      • Disable the direct edit option in Excel
      • Turn off Excel Scroll Lock option
    • Word tips
      • Create an automatic table of contents with Word
      • Delete a horizontal line in Microsoft Word
      • Insert a comment in Word margin
  • IT concepts
    • Dimension table definition in Business Intelligence
    • DSS or Decision Support System definition
    • EPM or Enterprise Performance Management definition
    • OLTP and Transactional Databases definition
  • MS-DOS commands
  • Useful SQL
    • Insert into from a select query
    • SQL Server insert or update query example
  • Time and dates
    • Display full month name in SQL Server?
    • Time difference in hours minutes
  • Strings
    • Split text after character with SQL Server Substring
    • Remove SQL line break from text
    • Split long SQL Server text in lines
  • SQL Server
    • SQL Server Abbreviations
    • SQL Server Downloads
    • SQL Server Errors
  • DAX functions
HomeDAX functions

DAX functions

In this DAX functions and examples section, we propose DAX functions scripts examples to calculate different values in SSAS Cube in tabular mode or Power BI reports. DAX functions are also called DAX Formulas.

The DAX language is the base programming language for SQL Server Analysis Services in tabular mode, Power BI desktop or service and also in Excel PowerPivot.

The type of functions available, for example :
– Date and time functions
– Time-intelligence functions
– Filter functions

The available articles so far are:

  • How to calculate Year-To-Date value in DAX with Power BI?
  • How to calculate the last year value in DAX with Power BI?
  • Or how to calculate the last month value in DAX with Power BI?
DAX functions

Calculate last month value in DAX with Power BI

September 3, 2020

How to calculate the last month value in DAX for Power BI? Managers, Financial advisors and Business consultants use month comparisons extensively. To create these comparison measures, use the DAX time intelligence functions …

DAX functions

Calculate year-to-date value in DAX with Power BI

July 23, 2020

How to calculate a year-to-date value of the sales in DAX with Power BI? Also called YTD, it represents the total to date of a given measure. For example, to calculate the year-to-date …

DAX functions

Calculate last year value in DAX for Power BI

October 31, 2019

With Power BI, how to calculate the last year value in DAX? Simply use the two available DAX CALCULATE function combined with the PREVIOUS YEAR function. In financial dashboard and reports, use the …

Follow Us

Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
WhatsApp

POPULAR POSTS

  • Calculate last month value in DAX with Power BI
    September 3, 2020
  • Time economy is key when you create a SQL Server partition.
    Create a SQL Server table partition
    August 26, 2020
  • SQL Server Violation of unique key constraint
    May 31, 2017
  • Delete Windows files recursively in cmd
    January 27, 2022

LATEST POSTS

  • Delete Windows files recursively in cmd
    January 27, 2022
  • Delete a file in Windows cmd
    January 26, 2022
  • Ralph Kimball’s bottom-up business intelligence modelling
    January 25, 2022
  • Download and install the OLEDB driver for Excel 2010
    January 24, 2022

2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.