Forum Discussion
IF formulas with different Data type column
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 |
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]))
4 Replies
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
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 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]))
