Calculate Sum Month Year

[BachFel]

WorkingTime_Jan = Calculate ( Sum (LN[ArbeitszeitInH]))

There is a column in the table "LN" with dates. I want to summarize only the operations which had taken place in January 2018. The date format is dd.mm.yyyy

Is there a possiblity to use a wildcard or something like that?

[Anonymous · Accepted solution]

@BachFel,

Create a measure using DAX below. If you don't  get expected result, please share dummy data of your table.

WorkingTime_Jan = CALCULATE(SUM(LN[ArbeitszeitInH]),FILTER(LN,YEAR(LN[DateKey])=2018 && MONTH(LN[DateKey])=1))

Regards,
Lydia