DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2

Part 2: BI Architect and SSAS Maestro Bill Pearson continues the exploration, comparison and contrast of the nature and operation of calculated columns and calculated measures begun in the first article of the series. He then introduces DAX functions for Counting and Filtering.

Read this article...

William Pearson

Bill has been working with computers since before becoming a "big eight" CPA, after which he carried his growing information systems knowledge into management accounting, internal auditing, and various capacities of controllership.

Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base. Bill's background as a CPA, Internal Auditor and Management Accountant enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Moreover, as a Certified Information Technology Professional (CITP) - a  CPA recognized for his or her unique ability to provide business insight by leveraging knowledge of information relationships and supporting technologies - Bill offers his clients the CPA's perspective and ability to understand the complicated business implications and risks associated with technology. From this perspective, he helps them to effectively manage information while ensuring the data's reliability, security, accessibility and relevance.

Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, etc.) in regular conversions of these once-dominant applications to the Microsoft BI stack.

comments powered by Disqus