blank keyword

[Anonymous]

i tried this expression for last year sales but this shows BLANK instead of 0 .. how to show 0 when there is no amount/data

expression

last_year_sales = var current_year= YEAR(MAX(Data[Date Main])) return  CALCULATE(SUM(Data[Net Sales]) ,(FILTER(Data,Data[Year]=current_year -1))
)

[lukiz84]

Hi,

last_year_sales =
   var current_year= YEAR(MAX(Data[Date Main]))
   return
      CALCULATE(
         SUM(Data[Net Sales]), 
         (FILTER(Data,Data[Year]=current_year -1))
      )+0

[Anonymous]

@lukiz84 this shows an error also 

[lukiz84 · Accepted solution]

just add a "+0" at the end of your CALCULATE()

[Anonymous]

@Anonymous 

last_year_sales =
VAR current_year =
    YEAR ( MAX ( Data[Date Main] ) )

VAR previous_year = 
    CALCULATE (
        SUM ( Data[Net Sales] ),
        (
            FILTER ( Data, Data[Year] = current_year - 1 )
        )
    )

RETURN

if(previous_year = "", 0, previous_year)

Try this

[lukiz84]

This can't work because previous_year is a number. You can't compare a number to a string. You could only compare it to blank

IF(ISBLANK(previous_year), 0, previous_year)

[Anonymous]

@Anonymous this shows an error 

[Anonymous]

@Anonymous 

last_year_sales =
VAR current_year =
    YEAR ( MAX ( Data[Date Main] ) )

VAR previous_year = 
    CALCULATE (
        SUM ( Data[Net Sales] ),
        (
            FILTER ( Data, Data[Year] = current_year - 1 )
        )
    )

RETURN

if(previous_year <= 0, 0, previous_year)

Try this instead

[lukiz84]

this won't help either. <= 0 is not BLANK()