Forum Discussion

Faradyn's avatar
Faradyn
Regular Visitor
10 years ago

Customer Net per Year – Change vs LY %

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

~

 

Need Help

2 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    10 years ago

    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