Check row for a status date in multiple columns to create an overall status

[TwinJohnson]

Hello,

I have the excel formula and trying to create the DAX formula to show the same expected results per row below.

In excel the formula works to obtain the overall status below =CHOOSE(COUNTIFS(A2:C2,"<="&TODAY())+1,"No Entry Sent","Entry Sent","Released/Not Delivered","Delivered")
When I translate each of these CHOOSE = SWITCH , COUNTIFS = CALCULATE(COUNTROWS( ...... but then I get to the column source and since I can't select a column A2:C2 I'm not sure how to write the remainder of the code

Thanks
Tawnee

Entry	Released	Delivery	Overall status (expected results)
			No entry sent
7/1/2021			Entry Sent
7/1/2021	7/2/2021		Released/Not Delivered
7/1/2021	7/14/2021	7/15/2021	Delivered