Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616

Posted on by Annie D

Download Excel Start File: https://ift.tt/2WBqJps
Download Excel Finished File: https://ift.tt/2NaqKhc
Learn how to bring an item from an Excel Cell in a DAX Formula in the Excel Power Pivot Data Model. Learn how to refresh the single Variable Query. Learn how to record a Macro and assign it to a button for easy refreshing.
Topics:
1. (00:01) Introduction
2. (00:27) Bring an item from an Excel Cell in a DAX Formula in the Excel Power Pivot Data Model.
3. (01:40) Use VALUES DAX Function to bring variable from an Excel Sheet to a DAX Measure.
4. (02:42) Build a Data Model PivotTable.
5. (03:20) Learn how to refresh the single Variable Query.
6. (03:50) Learn how to record a Macro and assign it to a button for easy refreshing.
7. (05:25) Summary

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.