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

BalaVenuGopal's avatar
BalaVenuGopal
Resolver I
8 years ago

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'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.