Forum Discussion

michaeln's avatar
michaeln
Regular Visitor
9 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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.