A Table of Measures

SHERRY PARKER (The Greenbrier Companies) – A Table of Measures

When replicating business reports in Power BI it often comes up that we need to display a group of measures in a table view.  It is not possible to simply drag a variety of measures into the table view and see them in a “list” format they same way you can in Excel.  There is, however, a trick using the DAX SWITCH function that can be utilized to achieve this goal providing your end user with the look they have requested.  She will walk through how to implement this approach for monthly reporting.

Sherry Parker is a BI Analyst with years of experience in reporting Manufacturing data, starting in Excel and moving to Power BI for the last two years.  She has worked at local manufacturing companies for the last 20 years, and is currently at The Greenbrier Companies as a BI Analyst.  The Greenbrier Companies, headquartered in Lake Oswego, Oregon, is a leading international supplier of equipment and services to the freight rail transportation markets.

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.