topic Re: How to calculate column wise Percentage Change for all month ex - 20-7/20,7-5/7 in DAX Commands and Tips

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

Subham_Ranjan — Tue, 28 Jan 2025 12:09:11 GMT

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

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

bhanu_gautam — Tue, 28 Jan 2025 13:26:33 GMT

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.

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

rohit1991 — Tue, 28 Jan 2025 14:36:05 GMT

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() )

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

Subham_Ranjan — Wed, 29 Jan 2025 03:32:09 GMT

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)

)