calculation

[abc_777]

Hi,

I have a calculation error

Target Quantity Company (Yearly) =

var a = CALCULATE([Same Month Previous Year Quantity],SAMEPERIODLASTYEAR(BMCalendar[Date]))

    return

        if(ISBLANK(a),[Same Month Previous Year Quantity], a * 1.2 )

but expected result should be 4271791.66 * 1.2 =  5,126,149.992 but my Target Quantity Company (Yearly) gives me 2641923.67.

please correct me 

thanks

[Ritatyna]

Looks like you made a mistake in your DAX. Try 
Target Quantity Company (Yearly) =
VAR a = CALCULATE([Same Month Previous Year Quantity], SAMEPERIODLASTYEAR(BMCalendar[Date]))
RETURN
IF(ISBLANK(a), [Same Month Previous Year Quantity] * 1.2, a * 1.2)

[abc_777 · Accepted solution]

its k i correct it