Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Pace needed to hit budget


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. 

Thank you!


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors