Customer Net per Year – Change vs LY %

[Faradyn]

Hello there,

I have this bar chart showing the customer net per year.

I need a line/measure to be shown that represents the change of customer net in relation to the previous year in %. I have no idea how to approch this and hope that you can give me some pointers.

The data basis of the bar chart above is from one table:

If you need more information regarding my issue in order to help me feel free to ask.

Regards from Germany

~

[Eric_Zhang]

@Faradyn

I'd use a calcuated table as this.


Check more details in the atached pbix. If you have any question, feel free to let me know.

[MattAllington]

Welcome to Power BI. You need to learn to write some DAX.  Is your data at a year level, or lower level?  Either way, create a calendar table at the same level or granularity as your data. Read about calendar tables on my website here 

http://exceleratorbi.com.au/power-pivot-calendar-tables/

Take note of the section titled "How to use a Week or Month Calendar". If your data is in yearly buckets, you will write a formula as a "year calendar". 

There red is a lot to learn, and there are a lot of things different to Excel. You may find my book useful. http://xbi.com.au/learndax