Excercise #64 question

A dedicated forum to help people when working through the book "Learn to Write DAX"
peterhof3
Posts: 7
Joined: Wed Jun 21, 2017 3:36 am

Excercise #64 question

Postby peterhof3 » Wed Jul 05, 2017 4:59 am

I am trying to work through Exercise 64 the formula that I have created is:

Total Sales FYTD March 31:=TOTALYTD([Total Sales Amount] ,
Calendar[Date], "3/31")

Now, the answer to the exercise as listed in the book is:

Total Sales FYTD 31 March =TotalYTD([Total Sales Amount], Calendar[Date], "31/3") [Total Sales Previous Month]
= Calculate([Total Sales Amount],
PreviousMonth(Calendar[Date])
)

I "think" that somehow the printing got "merged", as if I try and write the formula as written I get error messages.

PhilC
Posts: 145
Joined: Tue Sep 09, 2014 8:13 am

Re: Excercise #64 question

Postby PhilC » Thu Jul 06, 2017 1:37 pm

Yep. Fairly easy to see that the [Total Sales Previous Month] portion is actually #65, and #65/66 are mislabeled as well.


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

Who is online

Users browsing this forum: No registered users and 1 guest