I'm trying to get the Target value to show pace needed to hit budget on the Gauge visual. Maxium is sales goal through current month & Value is the Net sales to date. I want it to update each day with the pace needed to hit budget based on todays date until end of current month.
Here is one I used for a different slide
Pace needed to hit budget = If('Date Table'[Work Day]="WorkingDay",CALCULATE(SUM('Production Budgets 2022'[Production Goal Per Day]),'Date Table'[Date].[Date]),BLANK()) -- the difference is I don't need an IF formula.