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 )

     

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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 )