cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmyBuk
New Member

Total Sales as a % of Last Year Sales Gauge

Hi

 

I'm new to Power BI and teaching myself as I go.  I've looked around but cannot find a solution to this.  I have columns of data showing Sales and Sales LY.  I'd like to use a gauge with Sales LY as the Max which is fine, with a target value of X% of Sales LY - this is where I am struggling.

 

If anyone could help I'd be really grateful.

 

Many thanks

1 ACCEPTED SOLUTION
AmyBuk
New Member

Sorry for not being clear enough.

 

I think I've figured it out.  I've created a new measure which is:

 

= Sum([Sales LY]) * 0.75

and popped that measure into the maximum value box

 

I should have played around more before asking for help - sorry, and thanks for your responses.

 

 

View solution in original post

3 REPLIES 3
AmyBuk
New Member

Sorry for not being clear enough.

 

I think I've figured it out.  I've created a new measure which is:

 

= Sum([Sales LY]) * 0.75

and popped that measure into the maximum value box

 

I should have played around more before asking for help - sorry, and thanks for your responses.

 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@AmyBuk , Not very clear on the context. But you can get with time intelligence and date calendar

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
//Only year vs Year, not a level below

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...


Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

parry2k
Super User III
Super User III

@AmyBuk can you share an example, it is not clear what you are trying to do and what is missing?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors