Replicate Excel formula

[Syndicate_Admin]

Hello everyone. I'm trying to replicate a formula made in Excel that I can't perform in Power BI.

IF(Y(BI2="other"; F2>"15:59:59"; BE2=1);0;IF(Y(BI2="Friday"; F2>"15:09:59"; BE2=1);0;1))

How should I do that in Dax language?

Thank you

[amitchandak]

@Syndicate_Admin , we use column not cell in DAX

Switch(True(),

[BI] ="other" && [F] >time(15,59,59) && [BE] =1, 0,

[BI] ="Friday" && [F] >time(15,09,59) && [BE] =1, 0,

1)