Page 1 of 1

OR formula does not work (page 67)

Posted: Wed Jul 11, 2018 5:18 am
by Katja_O
Hi

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,

Katja

Re: OR formula does not work (page 67)

Posted: Wed Aug 08, 2018 11:44 pm
by Dave
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