increasing values measure dax

[Anonymous]

hello everyone.

I have a dax measure question, and I would appreciate anyone who can help. 

The Dax measure I am trying to create should sum values between months and increase in by "x" percentage each month after

To be more precise am trying to:

1. get the sum of the "values" of January and February
2. then I would like for that the summed values of January and February to  continuously  increase by 0.02 each month  

please see the table below for reference, and the desired outcome as well

I appreciate all the help I can get. Thank you!

[Vera_33 · Accepted solution]

Hi @Anonymous 

You want a measure or a calculated column? Here is a column

Column = 
VAR CurDate = Table1[Date]
VAR FirstValue = SUM(Table1[value])
VAR N = COUNTROWS( FILTER(Table1,Table1[Date]<CurDate))-1
RETURN
IF(Table1[value]=BLANK(),FirstValue+0.02*N,Table1[value])

[Anonymous · Accepted solution]

HI @Anonymous,

I think you can write a measure with variable and summarize function and replace the blank value to 0.02, then you can summary them based on the current date.

measure =
VAR currDate =
    MAX ( 'Table'[Date] )
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( 'Table' ),
        [Date],
        "Replaced", MAX ( MAX ( 'Table'[Value] ), 0.02 )
    )
RETURN
    SUMX ( FILTER ( summary, [Date] <= currDate ), [Replaced] )

Regards,

Xiaoxin Sheng

[Vera_33 · Accepted solution]

Hi @Anonymous 

You want a measure or a calculated column? Here is a column

Column = 
VAR CurDate = Table1[Date]
VAR FirstValue = SUM(Table1[value])
VAR N = COUNTROWS( FILTER(Table1,Table1[Date]<CurDate))-1
RETURN
IF(Table1[value]=BLANK(),FirstValue+0.02*N,Table1[value])