Time lapse for actual vs target

[shalnark0727]

Hi guys. How can I do a timelapse for sales vs target? Here's the sample table and desired output. Thanks.

Table 1

Client	Date	Invoice_amount
Sam	01/10/2019	1000.00
Bob	01/14/2019	2000.00
John	01/20/2019	5000.00
Paul	01/25/2019	15000.00

Table2

Month	Target_sales
January	31000.00

Desired output is a guage showing total sales of 23,000 & target of 25,000 (as of January 25) instead of 23,000 & target of 31,000. Then the next day (January 26) it will show a target of 26,000, thanks.

[Greg_Deckler · Accepted solution]

If the target is $1,000 per day then you could create a "goal" measure perhaps that was simply:

Measure = 

VAR __max = MAX([Date])

VAR __day = DAY(__max)

RETURN

__day * 1000

[Greg_Deckler]

Where does the target of $25,000 come from? Is that a percentage of the total for January or ?