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

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.