Double Or function

Hi Roxy_Kdk 

Please try below code

IN is better, when you are using OR function

Weekend =
IF('Calendar'[Day Name] IN {"Sunday","Saturday"}
,"Y"
,"N")

or 

Weekend =
IF('Calendar'[Day Name]="Sunday" || 'Calendar'[Day Name]="Saturday",
,"Y"
,"N")

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

Hello,
 
Try this where you replace // with || in the formula.


Weekend =
IF(
'Calendar'[Day Name] = "Sunday" || 'Calendar'[Day Name] = "Saturday",
"Y",
"N"
)