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 ...
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)
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)
  • aignn's avatar
    aignn
    Helper II
    6 years ago

    az38 Super! Thanks!