topic Re: datediff column -Power bi in DAX Commands and Tips

datediff column -Power bi

drgrd13 — Wed, 27 Apr 2022 19:29:40 GMT

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]-MAX(TODAY(),[@DueDate]))

DueDate	PromiseDt	to Due
27-Jan-22		Uncommitted
01-Feb-22	22-Apr-2022	-5
17-Apr-22	06-May-2022	9
08-Aug-22	08-Aug-22	0
12-Oct-22	27-Apr-2022	-168
17-Apr-22	8-May-2022	21
07-Jun-22	12-Jul-2022	35
12-Jul-22	12-Jul-22	0

Re: datediff column -Power bi

tamerj1 — Wed, 27 Apr 2022 20:10:45 GMT

Hi drgrd13

you may Create a new Column

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

Re: datediff column -Power bi

drgrd13 — Wed, 27 Apr 2022 20:27:55 GMT

Thank you for the help but the formula is resulting in an error msg as below

Re: datediff column -Power bi

tamerj1 — Wed, 27 Apr 2022 20:43:51 GMT

drgrd13

Yes this is not allowed. You can retun blank

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

Or otherwise, you can return the date as string.