IF formulas with different Data type column

[Chidi2]

Hello all: 

Please i need some help on how to if statement on Power BI 

I have this Table below.  I  am trying to create a new Column- (Date posted) that will compare "Date Completed" With Delivery.

I am trying to copy over Date Completed to the new Column-(Date Posted)  if there is a Date on Date Completed,  but if is blank,  Check if Complete date is blank and Delivery has any value, i will covert the to todays date using Now(),

if both Date Completed and Delivery  is blank then  the "Date Posted" should be blank. 

IF(AND(Date Complete =isblank(), Delivery (Value)), NOW(), 

    IF(Date Complete =Value, Date Complete, Blank()

Date Completed	Delivery	Posted Date
2/14/2018	DL229	2/14/2018
2/14/2018	KD317R	2/14/2018
2/15/2018	5DL290R	2/15/2018
2/15/2018		2/15/2018
2/16/2018	M2290_3	2/16/2018
	PD2C5	Todays date (Now()
	CNL2290R	Todays date (Now())
2/16/2018		2/16/2018
2/16/2018		2/16/2018

[BalaVenuGopal]

Hi @Chidi2 ,

Once your data is loaded on left hand panel you will have 3 icons

1) Report icon

2)Table icon

3)Relationship icon

just you click table icon and select your table from right panel -->go to Modeling tab on top --> Add column then use bellwo formula for new column.

Date posted = IF(ISBLANK(DateCompleted),TODAY(),DateCompleted)

If this works for you please make this is solution.

Thanks

[Chidi2]

Thanks for the formular BalaVenuGopal, i have tried that fomular it did not work.  i wil like to keep Posted Date Blank When both Delivery Date Completed is Blank.  

Desired output,-- Posted date should be blank when Date Completed and Delivery are blank. 

                             Posted Date should be today() when Date Completed is blank()

                             Posted Date should be Date Completed when Date completed is not Blank()

Date Completed	Delivery	Posted Date
2/14/2018	DL229	2/14/2018
2/14/2018	KD317R	2/14/2018
2/15/2018	5DL290R	2/15/2018
2/15/2018		2/15/2018
2/16/2018	M2290_3	2/16/2018
	PD2C5	Todays date (Now()
	CNL2290R	Todays date (Now())
2/16/2018		2/16/2018
2/16/2018		2/16/2018

your Formular--Date posted = IF(ISBLANK(DateCompleted),TODAY(),DateCompleted) Gives me this: 

Date Completed	Delivery	Posted Date
2/14/2018	DL229	2/14/2018
2/14/2018	KD317R	2/14/2018
2/15/2018	5DL290R	2/15/2018
2/15/2018		2/15/2018
2/16/2018	M2290_3	2/16/2018
		Todays date (Now()
	PD2C5	Todays date (Now()
	CNL2290R	Todays date (Now())
2/16/2018		2/16/2018
		Todays date (Now()
2/16/2018		2/16/2018

[Chidi2 · Accepted solution]

@BalaVenuGopal

i try using AND on the Formula it work. 

Posted Date = if(and(ISBLANK(Sheet1[Date Completed ].[Date]),ISBLANK(Sheet1[Delivery])),BLANK(),if(ISBLANK(Sheet1[Date Completed ].[Date]),today(),Sheet1[Date Completed ].[Date]))

[v-chuncz-msft]

@Chidi2,

By the way, you may help accept solution. Your contribution is highly appreciated.