cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors