cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mauriceph
New Member

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.

1 ACCEPTED SOLUTION
Luis98
Resolver II
Resolver II

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

View solution in original post

1 REPLY 1
Luis98
Resolver II
Resolver II

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors