Forum Discussion

aignn's avatar
aignn
Helper II
6 years ago
Solved

how do I return zero instead of empty?

Hi all!

 

I need help 😃

 

I have measure:

 

Measure = var test = "2020-01-18T00:00:00"
return 
CALCULATE(MAX('query1'[Complete]));'query1'[Date] = test)

 

The result is an empty value. It is right. Because there is no data for this date yet. But is it possible to output zero instead of empty?

Need Help
  • az38's avatar
    az38
    6 years ago

    Hi aignn 

    try

    Measure = var test = "2020-01-18T00:00:00"
var _Result = CALCULATE(MAX('query1'[Complete]));'query1'[Date] = test)
return 
if(isblank(_Result);0;_Result)

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi aignn 

    try

    Measure = var test = "2020-01-18T00:00:00"
var _Result = CALCULATE(MAX('query1'[Complete]));'query1'[Date] = test)
return 
if(isblank(_Result);0;_Result)