How to calculate Growth Rate between 2 desired quarters?

[mohammad-saber]

Hi all,

I have a table in Power BI as below:

What I need to calcualte is the growth in the "Customer Numbers" betweeon 2 desired Quarters for every Retailer, Fuel, Customer Type.

I've added drop down lists to the report for the user to select the desired quarters like below:

I think I need to create a measure with general formual like below:

Growth Rate =
DIVIDE(
Customer_Number for [End Quarter Value] - Customer_Number for [Start Quarter Value],
Customer_Number for [Start Quarter Value],
0
)

But, I don't know how to pass the selected Quarters to the above formula. Is there any way to do so?

Data is quarterly. FY starts from July unitl next June. 

• Q1 July to September; Q2 October to December; Q3 January to March; Q4 April to June

Please note that I need to be able to slice the Growth by Retailer, Fuel, Customer Type.

I am aware of the solutions to calcualte growth rate compared to the previous quarter or the same quarter in the previous year, but this is a different problem. 

Thanks for your help. 

--------------------------------------------------------------------------------------------

Sample data and report:

I uploaded the report to the Google Drive (URL).

Please refer to the page "Growth".

I tried to use a measure, but I am not able to return the value selected by user in the Drop-Down list to the measure:

Measure =

VAR A =

    CALCULATE (

        SUM(VIC[Customer Numbers]),

        FILTER( 'VIC', 'VIC'[FinYearQtr] = SELECTEDVALUE(FinYearQtr_Start) )

    )

VAR B =

    CALCULATE (

        SUM(VIC[Customer Numbers]),

        FILTER( 'VIC', 'VIC'[FinYearQtr] = SELECTEDVALUE(FinYearQtr_End) )

    )

RETURN

        DIVIDE(B-A, A, 0)

[Ahmedx · Accepted solution]

pls try this

Customer_Segmentation.pbix

[mohammad-saber]

@Ahmedx 

Many thanks for your help. 

Is it possible to show Growth for every Retailer? I mean, having a bar chart showing Growth for every Retailer. 
Also, I need to be able to slice the Growth based on the Fuel and Customer Type. 

Many thanks for your help. 

[mohammad-saber]

Thanks. 

I uploaded the report to the Google Drive (URL).

Please refer to the page "Growth".

I tried to use a measure, but I am not able to return the value selected by user in the Drop-Down list to the measure:

Measure =

VAR A =

    CALCULATE (

        SUM(VIC[Customer Numbers]),

        FILTER( 'VIC', 'VIC'[FinYearQtr] = SELECTEDVALUE(FinYearQtr_Start) )

    )

VAR B =

    CALCULATE (

        SUM(VIC[Customer Numbers]),

        FILTER( 'VIC', 'VIC'[FinYearQtr] = SELECTEDVALUE(FinYearQtr_End) )

    )

RETURN

        DIVIDE(B-A, A, 0)

[Ashish_Mathur]

Hi,

The problem is a lot easier to solve if you have a Date column.  Or even if you do not but instead have a Year and Month column that will do.  Share that dataset it you have what i alluded to.  Also, clarify the span of the FY.

[mohammad-saber]

Thanks. 

I uploaded the report to the Google Drive (URL). Table name is VIC in the report. 

Data is quarterly.

FY starts from July unitl next June. 

Q1 July to September; Q2 October to December; Q3 January to March; Q4 April to June

[Ahmedx]

Share sample pbix file to help you