Main background
Book availability status badge

The source of the book

This book is published for the public benefit under a Creative Commons license, or with the permission of the author or publisher. If you have any objections to its publication, please contact us.

Book cover of DAX Patterns by Marco Russo
Language: EnglishPages: 707Quality: excellent

DAX Patterns PDF - Marco Russo

Marco Russo • Information Systems • 707 Pages

(0)

Category

Technology

Number Of Downloads

210

Number Of Reads

282

File Size

48.68 MB

Views

4,752

Quate

Review

Save

Share

Book Description

A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel.The book includes the following patterns: Time-related calculations, Standard time-related calculations, Month-related calculations, Week-related calculations, Custom time-related calculations, Comparing different time periods, Semi-additive calculations, Cumulative total, Parameter table, Static segmentation, Dynamic segmentation, ABC classification, New and returning customers, Related distinct count, Events in progress, Ranking, Hierarchies, Parent-child hierarchies, Like-for-like comparison, Transition matrix, Survey, Basket analysis, Currency conversion, Budget.

Marco Russo

Marco Russo is a business intelligence consultant and mentor in Business Intelligence. He is a founder of SQLBI (www.sqlbi.com), which provides mentoring and consulting on Business Intelligence based on Microsoft technologies. He has particular competence and experience in sectors like financial services, manufacturing, gambling, and commercial distribution. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. In addition to his BI-related publications, he has authored books about .NET programming. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits.
Read More

Earn Rewards While Reading!

Read 10 Pages
+5 Points

Every 10 pages you read and spent 30 seconds on every page, earns you 5 reward points! Keep reading to unlock achievements and exclusive benefits.

Book icon

Read

Rate Now

5 Stars

4 Stars

3 Stars

2 Stars

1 Stars

Comments

User Avatar
Illustration encouraging readers to add the first comment

Be the first to leave a comment and earn 5 points

instead of 3

DAX Patterns Quotes

Top Rated

Latest

Quate

Illustration encouraging readers to add the first quote

Be the first to leave a quote and earn 10 points

instead of 3

Other books by Marco Russo

Copyright
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Copyright
Seminar on Stochastic Analysis, Random Fields and Applications V
Copyright
Programming Microsoft LINQ in Microsoft .NET Framework 4

Other books like DAX Patterns

Copyright
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Copyright
Seminar on Stochastic Analysis, Random Fields and Applications V
Copyright
Programming Microsoft LINQ in Microsoft .NET Framework 4
Copyright
Microsoft PowerPivot for Excel 2010: Give Your Data Meaning