cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## 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
Anonymous
Not applicable
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()
)
)
Anonymous
Not applicable
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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors