PowerPivot Forum

Posted: **Wed Jul 11, 2018 5:18 am**

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

Posted: **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

Dave

PowerPivot Forum

OR formula does not work (page 67)

OR formula does not work (page 67)

Re: OR formula does not work (page 67)