topic Re: Calcuate days between two dates without rows missing in DAX Commands and Tips

Calcuate days between two dates without rows missing

Anonymous — Mon, 06 Jun 2022 13:46:50 GMT

Tried to use this DAX expression:

DateDiff =

var DF = 1. * ([StartDate] - [EndDate])

return IF([StartDate] <> BLANK(), DF, TODAY())

Not all Rows have value on Column [StartDate] and [EndDate]. With Today() in DAX, will return all rows. However, without Today() in Dax, will return only those Rows with [StartDate] value. I don't want Today() value in column DateDiff and fill in Blank Value instead.

What DAX expression can make it

Re: Calcuate days between two dates without rows missing

Greg_Deckler — Mon, 06 Jun 2022 13:51:10 GMT

Anonymous Try returning BLANK() but then set the Show items with no data:

Re: Calcuate days between two dates without rows missing

Anonymous — Tue, 07 Jun 2022 01:45:49 GMT

Yes, Blank() works when checked "Don't summarize". Thx