Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure with if function should return value in date format

Dear all,   I am trying to create cards on my dashboard which show "nothing" whenever there is a BLANK value in my original measure. For that purpose I use the combination of IF and ISBLANK. I ma...
  • Greg_Deckler's avatar
    4 years ago

    Anonymous Perhaps:

    Earliest Start Date = if(isblank(min(Opportunities[StartDate])),"",min(Opportunities[StartDate]) & "")

    Or, use the FORMAT command for the last parameter.