Search found 7 matches

by peterhof3
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: 564

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
by peterhof3
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: 416

Re: Use of Filter Excercise 59

Phil,
Thanks for clearing that up, this sometimes gets confusing at the start.
by peterhof3
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: 564

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...
by peterhof3
Wed Jul 05, 2017 4:59 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Excercise #64 question
Replies: 1
Views: 368

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],...
by peterhof3
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: 416

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...
by peterhof3
Fri Jun 23, 2017 2:38 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Pg 61 example
Replies: 2
Views: 517

Re: Pg 61 example

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

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
Pg61 Matt A.PNG (8.41 KiB) Viewed 517 times
, I think I have filtered the Customer Number to the correct range.
TIA

Go to advanced search