Calcultate Total Revenue in a specific year using DAX

[Mauriceph]

I want to write a DAX that counts total revenue in 2015, I have two columns: Total rev, Duedate (date/time). Please help.

[Anonymous · Accepted solution]

You should use the next measure:

Revenue_2015 = 

CALCULATE(SUM(Name of table[Total rev]),YEAR(Name of table[Duedate])=2015)

You will need change Name of table with your real name of table