IF Statement Error

Question

HI,&nbsp;&nbsp;Im trying to create a separate column to complete all the dates to a have a final dates without blankOffer accepted column is blank get the date fromOffer Accepted Onboarding but if this is blankget the dates from Accepted forms reviewed but if this is blankget the dates from Forms completed but if this is blankget the dates Accepted Forms completed Pending ReviewI want the outcome like the Final Datesoffer AcceptedOffer Accepted (On Boarding)Accepted forms reviewedForms completedAccepted Forms completed Pending ReviewFinal Dates07/02/2022&nbsp;&nbsp;&nbsp;&nbsp;07/02/202218/02/2022&nbsp;&nbsp;&nbsp;&nbsp;18/02/202223/02/2022&nbsp;&nbsp;&nbsp;&nbsp;23/02/202223/02/2022&nbsp;&nbsp;&nbsp;&nbsp;23/02/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlankBlank24/02/2022&nbsp;24/02/2022BlankBlankBlankBlank05/04/202205/04/2022&nbsp;

mikelytics · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Can you please share some sample data and show the expected outcome?&nbsp;Best regardsMichael-----------------------------------------------------If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Appreciate your thumbs up!@ me in replies or I'll lose your thread.

anonymous · Answer

Data is similar like this, sorry tried posting as table but cant idk why&nbsp;&nbsp;

mikelytics · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Thank you but together with you descripition it is a little bit confusing to be hoenst.&nbsp;Please provide.&nbsp;- Input- Business rules- expected output incl. how visual should look like&nbsp;Best regardsMichael

anonymous · Answer

Mikelytics&nbsp;Sorry here's a better sample, i want the outcome as the Final Dates Column&nbsp;Offer AcceptedOffer Accepted (On Boarding)Accepted forms reviewedForms completedAccepted Forms completed Pending ReviewFinal Dates07/02/2022&nbsp;&nbsp;&nbsp;&nbsp;07/02/202218/02/2022&nbsp;&nbsp;&nbsp;&nbsp;18/02/202223/02/2022&nbsp;&nbsp;&nbsp;&nbsp;23/02/202223/02/2022&nbsp;&nbsp;&nbsp;&nbsp;23/02/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022Blank11/03/2022&nbsp;&nbsp;&nbsp;11/03/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlank11/05/2022&nbsp;&nbsp;11/05/2022BlankBlankBlank24/02/2022&nbsp;24/02/2022BlankBlankBlankBlank05/04/202205/04/2022

Forum Discussion

IF Statement Error

4 Replies

Related content

SQL Statement opcion error

IF STATEMENT ERROR

OR Statement ?

DAX error in IF statement

Support for MERGE statement

offer Accepted	Offer Accepted (On Boarding)	Accepted forms reviewed	Forms completed	Accepted Forms completed Pending Review	Final Dates
07/02/2022					07/02/2022
18/02/2022					18/02/2022
23/02/2022					23/02/2022
23/02/2022					23/02/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	Blank	24/02/2022		24/02/2022
Blank	Blank	Blank	Blank	05/04/2022	05/04/2022