Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need Help: Yearly step-down calculation based on a fixed percentage

Hi,    I'm new to DAX and I need help with coming up with a DAX computation   The scenario here is that at the start of each new year from [Period No.] = 8 onwards, I need to compute a degredatio...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    Anonymous 

     

    You may use DAX below to add a calculated column.

    Column =
VAR p = 'Table'[Period No.] - 8
RETURN
    IF ( p >= 0, 1 - QUOTIENT ( p, 4 ) * 0.7 / 100 )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Probably something like:

 

Degradation = 
VAR __period = [Period]
VAR __degradation = 
    IF([Period] < 8,
        BLANK(),
        INT( (__period - 😎 / 4) * .7
    )
RETURN 100 - __degradation

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg_Deckler 

 

This error shows up