OR formula does not work (page 67)

A dedicated forum to help people when working through the book "Learn to Write DAX"
Posts: 7
Joined: Tue Jul 03, 2018 2:40 am

OR formula does not work (page 67)

Postby Katja_O » Wed Jul 11, 2018 5:18 am


I cannot figure out what is happening with the OR formula. I am trying to make the calculation "Is weekend" on page 67.

Attached is the error that Power Pivot is showing me.

Can anyone see what is wrong with the formula?

Thank you in advance,

OR problem page 67.PNG
OR problem page 67.PNG (104.88 KiB) Viewed 3375 times

Posts: 4
Joined: Tue Jul 31, 2018 10:33 pm

Re: OR formula does not work (page 67)

Postby Dave » Wed Aug 08, 2018 11:44 pm

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


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

Who is online

Users browsing this forum: No registered users and 1 guest