How to compute the sales growth rate by competitor ?

[Paulyeo11]

Hi All

I have a table , may i know how to get the sales growth rate by competitor ? 

https://www.dropbox.com/s/9enfu4863y0piws/COMPETITOR_V009.pbix?dl=0

Above link is my PBI file

Paul

[v-jingzhang · Accepted solution]

Hi @Paulyeo11 

You could create a measure to calculate the growth rate. Here is the PBIX file.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Paulyeo11]

Hi Jing

I just notice that i cannot rename the TABLE to COMPETITOR :-

https://community.powerbi.com/t5/Desktop/How-to-re-name-my-Table-name-from-TABLE-to-COMPETITOR/td-p/...

Paul

[v-jingzhang]

Right click the table in Fields pane and select Rename. Then the table name used in all measures will be updated automatically.

[Paulyeo11]

Hi Jing

https://community.powerbi.com/t5/Desktop/How-to-re-name-my-Table-name-from-TABLE-to-COMPETITOR/td-p/...

Pls take a look at above link

Paul

[Paulyeo11]

Hi Jing

you are supper.

Pauk