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.
DAX Patterns book pdf by Marco Russo
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.