cancel
Showing results for
Did you mean:
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
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.

3 REPLIES 3
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.

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://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...

Proud to be a Super User!

Super User III

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

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

Announcements