Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Replicate Excel formula

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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)