Chapter 11 Values

A dedicated forum to help people when working through the book "Learn to Write DAX"
BradleyA
Posts: 2
Joined: Thu Sep 14, 2017 6:49 am

Chapter 11 Values

Postby BradleyA » Wed Sep 20, 2017 12:20 am

Hello, everyone

I am in the beginning of Chapter 11, trying to get the number of months in each year. The book shows
2001 - 6
2002 - 12
2003 - 12
2004 - 12

I am getting 13 for all years. No 6's no 12's :cry:

This is my formula:
Total Months in Calendar = COUNTROWS(VALUES('Calendar'[MonthName]))

I am using Power BI (July 2017 update). I made a table visualization and selected "Do not summarize" for both year and month count in the values section.

Any assistance is appreciated!

BradleyA
Posts: 2
Joined: Thu Sep 14, 2017 6:49 am

Re: Chapter 11 Values

Postby BradleyA » Wed Sep 20, 2017 12:53 am

I fixed the relationship for my calendar table and now I am getting all 12's instead of 13's. Still no 6 for 2001.

(I did all exercises already, but I am fixing relationships now since I am switching from using Access Tables to Queries as the data source. I thought the instructions said to use tables and replace "dim" prefix, but then it seems like column names in examples/exercises refer to the queries i.e. MonthName vs. EnglishMonthName).


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

Who is online

Users browsing this forum: No registered users and 1 guest