Hello,
When I get to the part where I have sorted the order of the Customer that have purchased, and then told to pull the Calendar[CalendarYear] into columns, my result is the same figures under all the years, in other words all the year columns are the same as the 'Customers that have purchased' column. I cant work out where I have gone wrong.
Regards,
P.
15. Customers that have purchased. Conditional Formatting.
-
- Posts: 7
- Joined: Sat Dec 10, 2016 2:43 pm
-
- Posts: 7
- Joined: Sat Dec 10, 2016 2:43 pm
Re: 15. Customers that have purchased. Conditional Formatting.
Worked it out, I made a similar mistake to the one in the thread, Page 47 Example Year Doesn't show. In the real world, how would we work out we have the correct relationships when faced with new data?
Regards,
Paul.
Regards,
Paul.
-
- Posts: 1019
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: 15. Customers that have purchased. Conditional Formatting.
Hi Paul
I'm not clear on the issue. Do you have relationships between all 4 lookup tables and the data table? You should only have to do this once and the rest should work.
I'm not clear on the issue. Do you have relationships between all 4 lookup tables and the data table? You should only have to do this once and the rest should work.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Power BI Training
-
- Posts: 7
- Joined: Sat Dec 10, 2016 2:43 pm
Re: 15. Customers that have purchased. Conditional Formatting.
HI Matt,
I think the mistake I have been making is when the book tells me to create a new pivot table, I am recreating the whole thing including the tables, rather than just creating a new pivot table within the existing spreadsheet! Totally new to this, so just working out how the book works (which I am really enjoying by the way!).
Regards,
P.
I think the mistake I have been making is when the book tells me to create a new pivot table, I am recreating the whole thing including the tables, rather than just creating a new pivot table within the existing spreadsheet! Totally new to this, so just working out how the book works (which I am really enjoying by the way!).
Regards,
P.
Return to “Help with the Book "Learn to Write DAX"”
Who is online
Users browsing this forum: No registered users and 1 guest