Show status based on date columns

Question

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 Answer

Please check attached pbix for more details.https://dropmefiles.com/SPbuDstatus_f = IF (&nbsp; &nbsp; NOT ISBLANK ( 'tbl'[Actuals due by] ),&nbsp; &nbsp; "Actuals",&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; NOT ISBLANK ( 'tbl'[Date Approved] ),&nbsp; &nbsp; &nbsp; &nbsp; "Approved",&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT ISBLANK ( 'tbl'[Sent for approval] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Awaiting approval",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOT ISBLANK ( 'tbl'[&nbsp;Reviewed] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Under review",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF ( NOT ISBLANK ( 'tbl'[Date Received] ), "Under review", "Not received" )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))

Forum Discussion

Show status based on date columns

1 Reply

Related content

Sequential Order column based on multiple criteria

Add duplicate row based on column

Matrix column based on other matrix columns

Status column based on another table

Count base from other column