Show status based on date columns

[perib]

Hello! I'm new to Power BI and I have no idea how to proceed. I have multiple columns with dates. I need to show a status column based on the latest date available. Here is an example:

Title	Tasker expiration	Date Received	Reviewed	Sent for approval	Date Approved	Actuals due by	Status
Event #1	11/28/2022	12/1/2022	12/2/2022				Under review
Event #2	12/12/2022						Not received
Event #3	11/28/2022	12/1/2022	12/5/2022	12/10/2022			Awaiting approval
Event #4	11/29/2022	12/1/2022	12/5/2022	12/10/2022			Awaiting approval
Event #5	11/30/2022	12/1/2022	12/7/2022				Under review
Event #6	12/1/2022	12/5/2022					Under review
Event #7	12/2/2022

Thank you in advance!

[Ahmedx · Accepted solution]

Please check attached pbix for more details.

https://dropmefiles.com/SPbuD

status_f =

IF (

    NOT ISBLANK ( 'tbl'[Actuals due by] ),

    "Actuals",

    IF (

        NOT ISBLANK ( 'tbl'[Date Approved] ),

        "Approved",

        IF (

            NOT ISBLANK ( 'tbl'[Sent for approval] ),

            "Awaiting approval",

            IF (

                NOT ISBLANK ( 'tbl'[ Reviewed] ),

                "Under review",

                IF ( NOT ISBLANK ( 'tbl'[Date Received] ), "Under review", "Not received" )

            )

        )

    )

)