Sales vs Objectives

[sdionne]

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

[parry2k]

@sdionne your sample attached file is missing.

[sdionne]

I don't know how attach file

Thanks

[v-lili6-msft]

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