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()
)
)

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors