Forum Discussion

sdionne's avatar
sdionne
Frequent Visitor
7 years ago

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