Forum Discussion

Mauriceph's avatar
Mauriceph
New Member
3 years ago
Solved

Calcultate Total Revenue in a specific year using DAX

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

Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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