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.

    Reply

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>

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below