cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Calculate Budget quantity till current month

Hi Guys,
I am trying to sum the quantity column from Jan to current month of this year. The measure should be dynamic that is if the month is July then the measure should calculate the quantity from Jan to July and if the month is August, then the measure should calculate quantity from Jan to August.

Really appreciate your help.
Thanks

1 ACCEPTED SOLUTION
Super User

Hi @powerbiss ,

You could create a measure as below:-

``````Measure =
CALCULATE (
SUM ( 'Table (3)'[quantity] ),
FILTER (
'Table (3)',
YEAR ( 'Table (3)'[budget_date] ) = YEAR ( TODAY () )
&& MONTH ( 'Table (3)'[budget_date] ) <= MONTH ( TODAY () )
)
)
``````

Output:-

BR,

Samarth

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

4 REPLIES 4
Super User

Hi @powerbiss ,

You could create a measure as below:-

``````Measure =
CALCULATE (
SUM ( 'Table (3)'[quantity] ),
FILTER (
'Table (3)',
YEAR ( 'Table (3)'[budget_date] ) = YEAR ( TODAY () )
&& MONTH ( 'Table (3)'[budget_date] ) <= MONTH ( TODAY () )
)
)
``````

Output:-

BR,

Samarth

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Helper I

Hi Samarth,

The DAX measure worked. Thanks for your help.

Super User

Try something like this

``YTD = TOTALYTD(SUM('table'[quantity]),'table'[budget_date])``

Helper I

Hey Syk,

The DAX measure is showing the whole year amount.

Thanks

## Helpful resources

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

#### Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors