cancel
Showing results for
Did you mean:  Helper II

## Simple calculation

Hi all,

I am calculate a simple increase rate: (YTD amount-Prior YTD amount)/Prior YTD amount

The measure is as follow:
Increase Selceted Day YTD = IF('Shop Account Ledger'[Prior YTD amount]<>BLANK(),
IF('Shop Account Ledger'[Prior YTD amount]=0,
'Shop Account Ledger'[YTD amount],
CALCULATE(('Shop Account Ledger'[YTD amount]-'Shop Account Ledger'[Prior YTD amount])/ABS('Shop Account Ledger'[Prior YTD amount]))
),BLANK()
)

However, when the denominator(Prior YTD amount) =0, the increase rate is blank, why? Thank you!

Branko

1 ACCEPTED SOLUTION  Helper II
I figured out:

Increase Selceted Day YTD = IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]=0,
'Shop Account Ledger'[YTD Selected Day Actual Amount],
IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]<>BLANK(),
CALCULATE(('Shop Account Ledger'[YTD Selected Day Actual Amount]-'Shop Account Ledger'[Prior YTD Selected Day Actual Amount])/ABS('Shop Account Ledger'[Prior YTD Selected Day Actual Amount])),
BLANK()
)
)  Helper II
I figured out:

Increase Selceted Day YTD = IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]=0,
'Shop Account Ledger'[YTD Selected Day Actual Amount],
IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]<>BLANK(),
CALCULATE(('Shop Account Ledger'[YTD Selected Day Actual Amount]-'Shop Account Ledger'[Prior YTD Selected Day Actual Amount])/ABS('Shop Account Ledger'[Prior YTD Selected Day Actual Amount])),
BLANK()
)
)  