Page 47 Example Year Doesn't show.

A dedicated forum to help people when working through the book "Learn to Write DAX"
StantonB
Posts: 5
Joined: Mon Dec 07, 2015 1:33 pm

Page 47 Example Year Doesn't show.

Postby StantonB » Tue Dec 08, 2015 2:32 pm

Hi Matt,

I've been working through the examples. I'm on page 47. I'm not understanding why. but when I add the Calendar[CalendarYear] to the columns. I don't see the yearly spread as shown in the book. I've rechecked my measures and table relationships and can't find where I'm going wrong. Any ideas? I have added a screen shot if that helps.
Attachments
Powerpivot question.png
Powerpivot question.png (5.45 KiB) Viewed 1345 times

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

Re: Page 47 Example Year Doesn't show.

Postby MattAllington » Wed Dec 09, 2015 4:00 pm

The things you have checked sound like the right things. I would have to take a look. Can you upload the workbook to Dropbox and post the link here so I can take a look?
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

StantonB
Posts: 5
Joined: Mon Dec 07, 2015 1:33 pm

Re: Page 47 Example Year Doesn't show.

Postby StantonB » Wed Dec 09, 2015 11:40 pm

Matt,
Having a little trouble uploading the file. You asked me to upload to Dropbox. Is this the same as using the attach file tab? If so, I tried to attach the file and it is too large. 3GB. Other than that, I'm not seeing another method. Sorry for coming across as such a dunce.

Stan

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

Re: Page 47 Example Year Doesn't show.

Postby MattAllington » Sat Dec 12, 2015 8:14 am

Hi Stan

Sorry for the slow reply - I have been crazy busy this week. The good news is you did the right things to try to find the problem. When ever something like this happens, you should first check if you have the correct columns in your Pivot, and then check that the relationships are correct. In your case you did have the relationship, but it was connected to the wrong column in the sales table.
stan.png
stan.png (48.1 KiB) Viewed 1310 times


Now I understand the logic of why you selected the OrderDateKey as that "seems" logical, but in this case it was not correct. These types of things happen all the time, and hence you have learnt a good bonus lesson to check that you have correct columns. :)
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

StantonB
Posts: 5
Joined: Mon Dec 07, 2015 1:33 pm

Re: Page 47 Example Year Doesn't show.

Postby StantonB » Mon Dec 14, 2015 1:22 pm

Thanks Matt.


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

Who is online

Users browsing this forum: No registered users and 1 guest