## Articles with tag DAX

Search for any content tagged dax

Items 1 to 20 of 48    Older >>

### Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.  Read more...
By Additional Articles 2019/02/18 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,275 reads

### Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.  Read more...
By 2019/02/14 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,270 reads

### SQL Server Reporting Services Report Builder with DAX Query Support

In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,293 reads

### Creating Measures Using DAX

In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model.  Read more...
By Additional Articles 2019/01/21 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,446 reads

### Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2019/01/09 (first published: 2015/01/14) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,867 reads

### Creating Calculated Columns Using DAX

In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.  Read more...
By Additional Articles 2018/11/22 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,395 reads

### Calculating Employee Attrition with DAX – Part 2

In part 1, we described the requirements for calculating attrition and also demonstrated one method that doesn’t rely on writing DAX code at all. In the second part of this tip, we introduce alternative methods of creating a calculation in DAX to calculate the number of employees that have left the company.  Read more...
By Additional Articles 2018/05/16 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,619 reads

### Calculating Employee Attrition Rate with DAX – Part 1

In many businesses, the HR department needs reports on the employee attrition. This is the number of people that leave the company (depending on the reason they leave; the terminology can also be dismissals or turnover). Suppose you have a table with your employee data, where you also store a possible termination date. How do you calculate the number of people who have left the company using the DAX query language?  Read more...
By Additional Articles 2018/05/15 | Source: MSSQLTips.com | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,698 reads

### Staying Current on Power BI Dashboards

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.  Read more...
By Angel Abundez 2018/03/01 | Source: SQLServerCentral.com | Category: powerbi
Rating: |  Discuss |   Briefcase | 1,101 reads

### Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.  Read more...
By Bill Pearson 2018/01/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 468 reads

### Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 436 reads

### Adding Time Intelligence to a Power BI Data Model

In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data  Read more...
By Adam Aspin 2017/10/27 (first published: 2016/06/06) | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 2,540 reads

### Extracting a DAX Query Plan With Analysis Services 2016 Extended Events

In this post, Koen Verbeeck shows how to use SQL Sever 2016's Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.  Read more...
By Additional Articles 2017/10/27 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,057 reads

### Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/07/12 (first published: 2015/01/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,085 reads

### Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/05/03 (first published: 2014/09/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,189 reads

### Non-Numeric Measures in DAX

Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date or Boolean measures.  Read more...
By James McGillivray 2016/12/06 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 713 reads

### Top 5 things you MUST know about PowerPivot for Excel

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.  Read more...
By Amir Charania 2016/11/25 (first published: 2015/01/12) | Source: SQLServerCentral.com | Category: powerpivot
Rating: |  Discuss |   Briefcase | 9,732 reads

### Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.  Read more...
By Bill Pearson 2016/09/21 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 1,069 reads

### Adding Time Intelligence to a Power BI Data Model

In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data  Read more...
By Adam Aspin 2017/10/27 (first published: 2016/06/06) | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 2,540 reads

### Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs: The DAX Product() and ProductX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX Product()and ProductX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Product()and ProductX(), respectively, in returning the product of numbers in a column and in returning the product of an expression evaluated for each row in a table.  Read more...
By Bill Pearson 2016/03/16 | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 277 reads
Items 1 to 20 of 48    Older >>