Forum Discussion
Sales vs Objectives
Hello, I did several searches without success, so here is my problem:
I have a sales table withh 2 columns (date and Sales $$) and I want to add a comparison indicator between the sales and the sales goal.
I want my selling goal to be a parameter of my pbix and the value is a monthly goal.
Also I would like the sales gap and the goal to be in proportion to the time.
Example, in my data file attached the month of March is not complete, so the comparison must be done according to the billing days.
I know, I can create a second table with month and goal, but I look for an other way using measure maybe
Thanks
sdionne
3 Replies
- sdionneFrequent Visitor
I don't know how attach file
Thanks
- v-lili6-msftCommunity Support
hi, sdionne
Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading
Best Regards,
Lin