DAX Patterns
id: 675212 not VIP
Open in MaM
By Marco Russo
Language: English
Category: Ebook - Computer/Internet
Categories: Computer/Internet
Uploader: SuperManny
Uploaded At: 2020-11-13 20:55:27
[Request] Data Modeling & Design, Business Software | 2020
Description
Publication date : August 10, 2020
Print length : 586 pages
Publisher : SQLBI Corp.; 2nd edition
ISBN: 978-1-7353652-0-6
Request #1599820403.80744
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.