Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from DAX Cookbook Over 120 recipes to enhance your business with analytics, reporting, and business intelligence

Product type Paperback

Published in Mar 2020

Publisher Packt

ISBN-13 9781839217074

Length 552 pages

Edition 1st Edition

Languages

DAX

Tools

Excel

Concepts

Business Intelligence

Author (1):

Greg Deckler

View More author details

Table of Contents (15) Chapters

Preface

1. Thinking in DAX

2. Dealing with Dates and Calendars FREE CHAPTER

3. Tangling with Time and Duration

4. Transforming Text and Numbers

5. Figuring Financial Rates and Revenues

6. Computing Customer KPIs

7. Evaluating Employment Measures

8. Processing Project Performance

9. Calculating Common Industry Metrics

10. Using Uncommon DAX Patterns

11. Solving Statistical and Mathematical Formulas

12. Applying Advanced DAX Patterns

13. Debugging and Optimizing DAX

14. Other Books You May Enjoy

Leave a review - let other readers know what you think

Technical requirements

The following are required to complete all of the recipes in this chapter:

Power BI Desktop
GitHub repository: https://github.com/PacktPublishing/DAX-Cookbook/tree/master/Chapter07

After downloading and opening the file for this chapter, go to File in the menu and then choose Options and settings. Choose Options. In the Options window under CURRENT FILE, choose Data Load and check the box under Time Intelligence for Auto date/time. This option was turned off for reasons of file size. Close the Options window.

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Greg Deckler

Greg Deckler is a 7-time Microsoft MVP for Data Platform and an active blogger and Power BI community member, having written over 6,000 solutions to community questions. Greg has authored many books on Power BI, including Learn Power BI 1st and 2nd Editions, DAX Cookbook, Power BI Cookbook 2nd Edition and Mastering Power BI 2nd Edition. Greg has also created several external tools for Power BI and regularly posts video content to his YouTube channels, Microsoft Hates Greg and DAX For Humans.

See other products by Greg Deckler