Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago
    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's avatar
Anonymous
Not applicable
3 years ago
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()
                                  )
                              )