sum of # to display in current month

[abcdefghij]

How do i get the calculate sum formula to only display the sum into the currently month instead of all the months as shown? Example 56 should only be shown for current month row (Jan 2024) not all months. Thanks!

[Daniel29195]

@abcdefghij 

write this code : 

new column  = 

var month  =  month ( today())

var year      =  year(today() ) 

var calc = 

sumx(

filter (

all ( tbl_name[ values.1] , tbl_name[curernt .. cdc] ) , 

year (tbl_name[ values.1])  = year      && month ( tbl_name[ values.1] ) = month  

)

var current_row_month = month(tbl_name[ values.1])

var current_row_year = year(tbl_name[ values.1])

return 

switch(

true() , 

current_row_month = month &&  current_row_year  = year       , calc  ) 

let me know if it works out for you . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡

[Daniel29195]

@abcdefghij 

NB : need to convert values.1 column to date if it is text 

[ryan_mayu]

@abcdefghij 

you can try to create a column

current month = if('Table'[date]>EOMONTH(today(),-1) && 'Table'[date]<EOMONTH(today(),0), "Y")

then sum the column value = "Y"

or create a column

Column = sumx(FILTER('Table','Table'[date]>EOMONTH(today(),-1) && 'Table'[date]<EOMONTH(today(),0)),'Table'[value])

pls see the attachment below