How to calculate average growth %?

Hi qixue,

 

You can try to use below formula to calculate the DoD growth %:

Measure:

 

DoD Growth = 
VAR current_Date =
    MAX ( 'Table'[Date] )
VAR current_amount =
    SUMX ( FILTER ( ALL ( 'Table' ), [Date] = current_Date ), [Amount] )
VAR previous_amount =
    SUMX ( FILTER ( ALL ( 'Table' ), [Date] = current_Date - 1 ), [Amount] )
RETURN
    DIVIDE ( current_amount - previous_amount, previous_amount, 0 )

 

 

>>Similarly, I will have growth % for each day. Now I want to show the average growth % by year and by month. How to achieve it? 

You can create a summary table with 'dod growth', then wirite a measure to calcuate the average. After these steps, create a table visual with different date column as the group, you can switch hierarchy levl to get the different average of current level.

 

Calculate table:

 

Summary table =
VAR summaried =
    SUMMARIZE ( 'Table', [Date], "Total Amount", SUM ( 'Table'[Amount] ) )
RETURN
    ADDCOLUMNS ( summaried, "DOD Growth %", [DoD Growth] )

Measure:

 

 

AVG DoD = AVERAGE('Summary table'[DOD Growth %])

 

Regards,

Xiaoxin Sheng