How to calculate column wise Percentage Change for all month ex - 20-7/20,7-5/7

[Subham_Ranjan]

Matrix 
Row = Signup_month
column  = Month No = DATEDIFF(bull_users[signup_date],bull_users[Purchase_date],Month)-0,1,2,3,4,5,6

Values = Count_of_user_id 

[rohit1991]

Hi @Subham_Ranjan 
To calculate the column-wise percentage change in a Power BI matrix, you need to compute the difference between the current and previous month's values and then divide by the previous month's value. Here’s how you can create a measure to achieve this:

 

Column_Wise_Percentage_Change = 
VAR _CurrentValue = SELECTEDVALUE(bull_users[Count_of_user_id])
VAR _PreviousValue = 
    CALCULATE(
        SELECTEDVALUE(bull_users[Count_of_user_id]), 
        bull_users[Month No] = MAX(bull_users[Month No]) - 1
    )

RETURN 
IF(
    NOT(ISBLANK(_PreviousValue)) && _PreviousValue <> 0,
    (_CurrentValue - _PreviousValue) / _PreviousValue,
    BLANK()
)

[bhanu_gautam]

@Subham_Ranjan 

Create a Measure for Percentage Change:

Percentage Change =
VAR CurrentMonth = SELECTEDVALUE('Table'[Month No])
VAR PreviousMonth = CurrentMonth - 1
VAR CurrentValue = CALCULATE(SUM('Table'[Count_of_user_id]), 'Table'[Month No] = CurrentMonth)
VAR PreviousValue = CALCULATE(SUM('Table'[Count_of_user_id]), 'Table'[Month No] = PreviousMonth)
RETURN
IF(
ISBLANK(PreviousValue),
BLANK(),
DIVIDE(CurrentValue - PreviousValue, PreviousValue, 0)
)

Drag the newly created measure Percentage Change to the Values area of the matrix.

You can format the measure as a percentage by selecting the measure in the Fields pane, then going to the Modeling tab and selecting the percentage format.

[Subham_Ranjan]

When i am calculating percentage change  of arpu it is not giving accurate result also i am using filter from filter pane where payment status = Success

ARPU = SUM(bull_users[bull_course_orders.Amount])/DISTINCTCOUNT(bull_users[bull_course_orders.user_id])

Percentage_Change =

VAR CurrentMonth = SELECTEDVALUE('users'[Month No])

VAR Previous_Month = CurrentMonth - 1

VAR CurrentValue = CALCULATE([ARPU], 'users'[Month No] = CurrentMonth)

VAR PreviousValue = CALCULATE([ARPU], 'users'[Month No] = Previous_Month)

RETURN

IF(

ISBLANK(PreviousValue),

BLANK(),

DIVIDE(CurrentValue - PreviousValue, PreviousValue)

)