Search found 3 matches

by Dave
Wed Aug 08, 2018 11:44 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: OR formula does not work (page 67)
Replies: 1
Views: 941

Re: OR formula does not work (page 67)

Hi Katja

It looks like the reason the formula isn't working is you are missing the IF part of it

The whole Formula should read

=IF(OR('Calendar'[DayNumberofWeek] = 1, 'Calendar'[DayNumberofWeek] = 7),"Weekend","Weekday")

hope that helps

Dave
by Dave
Wed Aug 01, 2018 5:15 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Ch19 Multiple Data Tables missing data
Replies: 2
Views: 146

Re: Ch19 Multiple Data Tables missing data

Hi RamanaV, thanks for your reply, Ive followed the steps that the book shows to add the budget tables, but dont get the option to add then once ive clicked on the data connection. I think this is because i have used the excel file '7 tables' to add the data rather than the access database and the e...
by Dave
Tue Jul 31, 2018 10:43 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Ch19 Multiple Data Tables missing data
Replies: 2
Views: 146

Ch19 Multiple Data Tables missing data

Hi,

I have reached Chapter 19 of Supercharge Excel but have the problem that the excel version of the data tables hasn't got the budget tables included in it, is it possible to get an excel version of these so i can carry on with the book?

many thanks

Dave

Go to advanced search

cron