Forum Discussion
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 ...
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)