Forum Discussion

powerbiss's avatar
powerbiss
Icon for Helper I rankHelper I
4 years ago
Solved

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...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Try something like this

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

 

powerbiss's avatar
powerbiss
Icon for Helper I rankHelper I
4 years ago

Hey Syk,

The DAX measure is showing the whole year amount. 

 

Thanks