SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sum() Rss

   Items 1 to 6 of 6   
 

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 | 357 reads

Curious Case of SUM Function

How a simple SUM statement could change an output.  Read more...
By Utsav Verma 2017/08/24 | Source: SQLServerCentral.com | Category: sum()
Rating: |  Discuss |   Briefcase | 1,858 reads

Type INT

By Lesole Sebego 2016/11/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,348 reads

Round averages

By Steve Jones 2016/09/29 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 1,343 reads

Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() 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 managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,240 reads

Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() 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 managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/12/24 (first published: 2014/08/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,240 reads
   Items 1 to 6 of 6   
 
Tags
aggregate function (3)    
t-sql (3)    
dax (2)    
power bi (2)    
calculation (1)    
card (1)    
column (1)    
count() (1)    
counta() (1)    
countax() (1)    
datatype (1)    
decimal (1)    
delimited (1)    
filter (1)    
formula (1)    
function (1)    
matrix (1)    
measure (1)    
numeric (1)    
pivottable (1)    
power bi desktop (1)    
powerpivot (1)    
productx (1)    
report (1)    
round() (1)    
slicer (1)    
stairway series (1)    
string (1)    
sumx() (1)    
visualization (1)