## Search found 7 matches

Fri Jul 07, 2017 12:01 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Time Intelligence Function Previous Day
Replies: 2
Views: 2428

### Re: Time Intelligence Function Previous Day

Phil;

This makes sense, and I will reference Rob's book to check on this.

Guess that one would have to hide the Grand Total, from a report, as I can see a business person look at that number and mentioning the fact that the "total does not add up".

Cheers
Thu Jul 06, 2017 11:55 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Use of Filter Excercise 59
Replies: 2
Views: 2088

### Re: Use of Filter Excercise 59

Phil,
Thanks for clearing that up, this sometimes gets confusing at the start.
Thu Jul 06, 2017 12:44 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Time Intelligence Function Previous Day
Replies: 2
Views: 2428

### Time Intelligence Function Previous Day

Doing exercise 66 using the Previous Day functions and have come across something "odd" Matt Previous Day.PNG If you look at the Grand Total Line it seems to be repeating the number for Day 1 when, if you do the math the total should be \$597,153 for the month. The question then is, do I ha...
Wed Jul 05, 2017 4:59 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Excercise #64 question
Replies: 1
Views: 1760

### Excercise #64 question

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],...
Wed Jul 05, 2017 1:39 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Use of Filter Excercise 59
Replies: 2
Views: 2088

### Use of Filter Excercise 59

This may just be a best practices question but curious non the less. In the answer posted to exercise 59 we have =Calculate ([Total Sales Amount]. Filter (Products, [Total Sales Amount] <= 10000 && [Total Sales Amount] > 0 )) Now if I re-write the formula like so: =CALCULATE( [Total Sales Am...
Fri Jun 23, 2017 2:38 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Pg 61 example
Replies: 2
Views: 2283

### Re: Pg 61 example

Ok, part of the issue is that Customer number 10001 thru 10010 does not exist in the dB!
Fri Jun 23, 2017 2:33 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Pg 61 example
Replies: 2
Views: 2283

### Pg 61 example

I am trying to replicate the table on pg. 61 (Under Dax Topic iterators).
When I add the [Visits] measure and add it to the table my results are not the same
Pg61 Matt A.PNG (8.41 KiB) Viewed 2283 times
, I think I have filtered the Customer Number to the correct range.
TIA