Comprehensive Power BI

Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a simple, step-by-step manner. This updated third edition covers new features introduced in 2018-2019. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; and how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages." The pattern-like techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars are now available within the pages of this easy-to-follow guide.