cancel
Showing results for
Did you mean:
Highlighted
Member

## Calculating YTD Goals

I have Sales Quotas that are basically fixed every month but I'm stumped on how to calculate the YTD Quota.

So, if every month the quota is \$60,000, obviouslt the YTD would be "\$60,000" and nextmonth would be "\$120,000" but I'm not sure how to write that measure

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Calculating YTD Goals

Hi @bhmiller89,

You can try to use below formula which used to calculate the running total:

Measure:

`TotalYTD=  Calculate(Sum(Table[AmountColumn]),Filter(ALL(Table),Table[DateField]<=Max(Table[DateField)&&Year(Table[DateField])=Year(Max(Table[DateField))))`

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Community Support Team

## Re: Calculating YTD Goals

Hi @bhmiller89,

You can try to use below formula which used to calculate the running total:

Measure:

`TotalYTD=  Calculate(Sum(Table[AmountColumn]),Filter(ALL(Table),Table[DateField]<=Max(Table[DateField)&&Year(Table[DateField])=Year(Max(Table[DateField))))`

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)