From Data To Analysis with Power Query and CUBEVALUE Function

In this project:

We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the Data Model in Power Pivot and  create a DAX function and a Pivot Table.

Finally with a drop list we filter the data in the Data Model using a CUBEVALUE function.

We test by adding more files to the source folder and refresh the query and everything magically updates.

You can Download all exercise files and Follow along by clicking on the button:

A picture containing drawing Description automatically generated



Watch the Video Tutorial Here:



Share This Post
Have your say!
1 0
1 Comment
  1. That was very good indeed. Thanks for sharing.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.