Forum Discussion

drgrd13's avatar
drgrd13
Helper I
4 years ago
Solved

datediff column -Power bi

Hi I want to create the same formula in power bi from Excel. But not too sure how to achieve this. the main formula used in Excel in column to DUE is =IF([@PromiseDt]=0,"Uncommitted",[@PromiseDt]-MA...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi drgrd13 

    you may Create a new Column 

     

     

    To Due =
IF (
    ISBLANK ( Table[PromiseDt] ),
    "Uncommitted",
    DATEDIFF ( Table[PromiseDt], MAX ( TODAY (), Table[DueDate] ), DAY )
)

     

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi drgrd13 

you may Create a new Column 

 

 

To Due =
IF (
    ISBLANK ( Table[PromiseDt] ),
    "Uncommitted",
    DATEDIFF ( Table[PromiseDt], MAX ( TODAY (), Table[DueDate] ), DAY )
)