How do I group by Year 2016 Vs 2017 based on total(MetricValue) in PowerBI.

[101Francisco]

Here is how my data looks. 

Question: How do I group by Year 2016 Vs 2017 based on total(MetricValue) in PowerBI. 

DateAdded	SalesFunnel	MetricCategory	MetricName	MetricValue
3/1/2016 0:00	eCom	Demand	eComStep1	1590
3/1/2016 0:00	LeadForms	Demand	LeadForms	746
3/1/2016 0:00	Phone	Demand	SalesCalls	1937
3/2/2016 0:00	eCom	Demand	eComStep1	1240
3/2/2016 0:00	LeadForms	Demand	LeadForms	794
3/2/2016 0:00	Phone	Demand	SalesCalls	1759

[v-yuta-msft · Accepted solution]

Hi 101Francisco,

Create a new calculate column using DAX:

Year = YEAR(Table1[DateAdded])

Then create a measure using DAX:

Total of 2016 = CALCULATE(SUM(Table1[MetricValue]), ALLEXCEPT(Table1, Table1[Year]))

Regards,

Jimmy Tao