Forum Discussion
multiple ifs
Hi, i have multiple conditions, how is this doable in power bi? IF ([SCHEDULE_SHIP_DATE] < TODAY() OR [SCHEDULE_SHIP_DATE] < TODAY() + 2) THEN 'Today' ELSEIF ([SCHEDULE_SHIP_DATE] < TODAY...
Hi Anonymous ,
You could try SWITCH() function.
https://docs.microsoft.com/en-us/dax/switch-function-dax
However, the second condition look wired.
([SCHEDULE_SHIP_DATE] < TODAY() OR [SCHEDULE_SHIP_DATE] < TODAY() + 2) could be both "Today" and "N5D"?
Best Regards,
Jay