Overview:
Mastering when to use a Calculated Column and when to use a Measure is key to reporting success and selecting the wrong one can result in poor report performance and incorrect results. But what are Calculated Columns? What are Measures?
Why you should Attend:
Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.
If you want to take your reporting capabilities to the next level by learning how to leverage the calculation functionality of Power Pivot, this is a must-attend training session!
Areas Covered in the Session:
Learning Objectives:
In this training, you will learn, using practical examples, how to use the DAX formula language to create and add calculated information to your Pivot Tables, providing you with even greater insights into your data
Who Will Benefit:
This training is aimed at users of Excel (2010 and above for Windows) who are familiar with the basics of Power Pivot and who wish to learn how to add calculations to their Pivot Tables
IMPORTANT NOTE: Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department
Mastering when to use a Calculated Column and when to use a Measure is key to reporting success and selecting the wrong one can result in poor report performance and incorrect results. But what are Calculated Columns? What are Measures?
Why you should Attend:
Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.
If you want to take your reporting capabilities to the next level by learning how to leverage the calculation functionality of Power Pivot, this is a must-attend training session!
Areas Covered in the Session:
- Creating Calculated Columns
- Using Calculated Columns to build a Slicer
- When to use a Calculated Column v when to use a Measure
- Working with Dates
- The Lookup Function
Learning Objectives:
In this training, you will learn, using practical examples, how to use the DAX formula language to create and add calculated information to your Pivot Tables, providing you with even greater insights into your data
Who Will Benefit:
This training is aimed at users of Excel (2010 and above for Windows) who are familiar with the basics of Power Pivot and who wish to learn how to add calculations to their Pivot Tables
IMPORTANT NOTE: Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department
Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.Who Should Attend
- This training is aimed at users of Excel (2010 and above for Windows) who are familiar with the basics of Power Pivot and who wish to learn how to add calculations to their Pivot Tables
