Forum Discussion

Chidi2's avatar
Chidi2
Regular Visitor
8 years ago
Solved

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 Deliv...
Need Help
  • Chidi2's avatar
    Chidi2
    8 years ago

    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]))

Chidi2's avatar
Chidi2
Regular Visitor
8 years ago

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 DeliveryPosted Date 
2/14/2018DL2292/14/2018
2/14/2018KD317R2/14/2018
2/15/20185DL290R2/15/2018
2/15/2018 2/15/2018
2/16/2018M2290_32/16/2018
   
 PD2C5Todays date (Now()
 CNL2290RTodays 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 DeliveryPosted Date 
2/14/2018DL2292/14/2018
2/14/2018KD317R2/14/2018
2/15/20185DL290R2/15/2018
2/15/2018 2/15/2018
2/16/2018M2290_32/16/2018
   Todays date (Now()
 PD2C5Todays date (Now()
 CNL2290RTodays date (Now())
2/16/2018 2/16/2018
   Todays date (Now()
2/16/2018 2/16/2018
Chidi2's avatar
Chidi2
Regular Visitor
8 years ago

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's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Chidi2,

     

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