Forum Discussion
Sales Target vs Actual
Hi- I'm a Power BI newb and I'm hoping you can help me figure this out...
In one table, I have a series of teams, their start date and their daily sales target. I formed it this was because I can get the days between their start date and today's date, then multiply that number of days with the daily sales target to know what their target was in the date range. Hopefully that makes sense.
In the second table, I have sales records stamped with their team and the date of the sale.
I'd like to do a series of visuals based on this, starting with a YTD Sales vs Target clustered bar chart with a team slicer.
It's easy enough to create the bar chart with sales and the slicer, but I can't figure out how to calculate and add the target amount for the date range... Can you point me in the right direction please? Thanks!!
1 Reply
- Greg_Deckler
Community Champion
Can you provide sample data and sample output? Please make sure sample data can be copied and pasted and is not a screen shot.