Finding Final amount Current Month ?

[Suman8877]

Hello, everybody 

Is there any dax command where I can see the total amount for the current month?. 

Many thanks,

[rohit1991 · Accepted solution]

Hi @Suman8877 

Yes, you can calculate the total for the current month using a measure like this:

CurrentMonthAmount =
CALCULATE(
  SUM('Sales'[Amount]),
   FILTER(
       ALL('Date'),
      MONTH('Date'[Date]) = MONTH(TODAY()) &&
      YEAR('Date'[Date]) = YEAR(TODAY())
   )
)

• Replace 'Sales'[Amount] with your column name.
• This will return the total amount only for the current month based on today’s date.

[FBergamaschi · Accepted solution]

Hi,

what you have in DAX is a set of funtions to get the end of month in terms of dates

https://dax.guide/eomonth/

https://dax.guide/endofmonth/

The last one can be used in a CALCULATE statement as filter as it returns a table

example

CALCULATE ( [Sales Amount], ENDOFMONTH ( Dates[Date] ) )

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[rohit1991 · Accepted solution]

Hi @Suman8877 

Yes, you can calculate the total for the current month using a measure like this:

CurrentMonthAmount =
CALCULATE(
  SUM('Sales'[Amount]),
   FILTER(
       ALL('Date'),
      MONTH('Date'[Date]) = MONTH(TODAY()) &&
      YEAR('Date'[Date]) = YEAR(TODAY())
   )
)

• Replace 'Sales'[Amount] with your column name.
• This will return the total amount only for the current month based on today’s date.