Filter a sum of column table

[AlessandroBet]

I have a table with several columns.

I need to calculate the sum of all the values of column "Price" but filtering the date "january" from other column

[amitchandak · Accepted solution]

@AlessandroBet 

Try like

calculate(sum(table[price]),format(Table[Date],"MMM")= "Jan")
calculate(sum(table[price]),format(Table[Date],"YYYYMM")= "202001")

[az38]

Hi @AlessandroBet 

smth like

CALCULATE(SUM('Table'[Price]), 'Table'[Date]="january" )

but correct answer depends on your data model and example