Topic: Power Pivot

       Page 5 of 177 blog posts
blog post –

Basket Analysis with #dax in #powerpivot and #ssas #tabular

A few days ago I published a new article on DAX Patterns web site describing how to implement Basket Analysis in DAX. This topic is a very classical one and is also covered in the many-to-many revolution white paper. It has been also discussed in several  Read more

blog post –

The ISEMPTY function in #dax #powerpivot #tabular

Microsoft silently added the ISEMPTY function to the DAX language in Analysis Services build 11.00.3368 (SQL Server 2012 SP1 CU4). This function is particularly important in DAXMD (when you use DAX to query a Multidimensional model), because produces  Read more

blog post –

Common Statistical #DAX Patterns for #powerpivot and #tabular

DAX includes several statistical functions, such as average, variance, and standard deviation. Other common algorithms require some DAX code and we published an article about common Statistical Patterns on , including: Average Moving  Read more