Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calcuate days between two dates without rows missing

Tried to use this DAX expression: DateDiff =                    var DF = 1. * ([StartDate] - [EndDate])                    return IF([StartDate] <> BLANK(), DF, TODAY())   Not all Rows have va...
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

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

     

  • Anonymous's avatar
    Anonymous
    4 years ago

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

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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