Ch19 Multiple Data Tables missing data

A dedicated forum to help people when working through the book "Learn to Write DAX"
Dave
Posts: 4
Joined: Tue Jul 31, 2018 10:33 pm

Ch19 Multiple Data Tables missing data

Postby Dave » Tue Jul 31, 2018 10:43 pm

Hi,

I have reached Chapter 19 of Supercharge Excel but have the problem that the excel version of the data tables hasn't got the budget tables included in it, is it possible to get an excel version of these so i can carry on with the book?

many thanks

Dave

RamanaV
Posts: 14
Joined: Thu Oct 19, 2017 12:57 pm

Re: Ch19 Multiple Data Tables missing data

Postby RamanaV » Wed Aug 01, 2018 1:34 pm

Hi,
You need to get the tables once again from AdventureWorks database.

Look at the section - Here’s How: Adding a Budget Table.
It has step-by-step instructions to do the same. Once you load the tables, you will see those tables also in the data model.

Hope this helps you in proceeding with Chapter 19.

Dave
Posts: 4
Joined: Tue Jul 31, 2018 10:33 pm

Re: Ch19 Multiple Data Tables missing data

Postby Dave » Wed Aug 01, 2018 5:15 pm

Hi RamanaV,

thanks for your reply,

Ive followed the steps that the book shows to add the budget tables, but dont get the option to add then once ive clicked on the data connection.

I think this is because i have used the excel file '7 tables' to add the data rather than the access database and the excel file dose not have the additional budget data in it.

for various reasons i cant use the access database to import the data and have to use the excel file, which has worked perfectly until this chapter.

is this data available in excel format?

many thanks

Dave

MattAllington
Posts: 992
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Ch19 Multiple Data Tables missing data

Postby MattAllington » Sat Sep 01, 2018 8:04 am

Hi Dave

Sorry I missed this post, and thanks for bringing this to my attention. I have fixed the issue - the budget files are now included in the download. Here they are here for you too.

Budget Files.xlsx
(11.78 KiB) Downloaded 26 times
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Dave
Posts: 4
Joined: Tue Jul 31, 2018 10:33 pm

Re: Ch19 Multiple Data Tables missing data

Postby Dave » Mon Sep 03, 2018 8:22 pm

That’s great

Many thank Matt


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest

cron