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