cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III

## Sales Target

Hi

I would like to create a monthly running sales target based upon last years profit figure +20%, i have a calculated column which gives me last years profit + 20% but would like to show this in a line graph against YTD profit.  Probably someone cleverer than me, which think of a easy way to achieve this as i am drawing a blank!!

Many thanks

3 REPLIES 3
Super User

http://www.daxpatterns.com/cumulative-total/

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper III

thank you, yes i can do the dax for these however i probably didint explain my problem, and i am not sure I can do what i am trying to acheive.

for example:

 Date Sales Achieved FY2017/18 Target Jan-16 100,000 125,000 Feb-16 125,000 156,250 Mar-16 150,000 187,500 Apr-16 125,000 156,250 May-16 130,000 162,500 Jun-16 140,000 175,000 Jul-16 100,000 125,000 Aug-16 125,000 156,250 Sep-16 150,000 187,500 Oct-16 125,000 156,250 Nov-16 130,000 162,500 Dec-16 140,000 175,000

the sales figures for 2016 were as above, and i would like to add 25% onto this figures to form the sales target for the following year ie 2017.  I would then like to display these on a line graph with YTD sales and also a Sales Target to show if we are ahead or behiand target and ideally a percentage figure

I can do a calcualted column adding 25% of the 2016 sales figures and its therfore gives me the sales target for 2017, but will obviously will display on the x axis against 2016 and not 2017.  I hope this is a better explaination

Microsoft

Hi @tmears,

Since you can get the monthly running sales, then, based on my understanding, you need to add this running values into a line chart, together with the FY2017/18 Target value, right? On X-axis, it displays the Date column, right?

I was confused about how you want to compare the YTD sales and Sales Target? Compare the Sales Achieved in year 2016 with the target sales in year 2017? It looks like make no sense.

To elaborate your desired output, would you please draw a picture to show us your expected line graph?

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors