DAX Patterns: Second Edition by Marco Russo

Marco Russo . Unknown Year . English

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.

Categories: Literary Fiction

About the Author

Marco Russo is a business intelligence mentor and consultant. He founded SQLBI, 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 in Microsoft Analysis Services. In addition to his BI-related publications, he has authored books about .NET programming. Today, Marco focuses his time on SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI, Fabric, and Analysis Services. Marco also teaches public classes worldwide. Marco also speaks at international conferences such as Microsoft Fabric, PASS Summit, and SQLBits.

Books from Similar Categories

Download BookR now and choose mindful reading!

Download Now!