Computing measures from aggregations

[tylerbauer]

I am working on a project where I have been given a Power BI file with a number of aggregations. I am trying to take a value revenue which is an aggregation value and put it in a measure to find Revenue Year-over-Year. However, when I try to create this new measure Revenue Year-over-Year, I am not able to include the aggregation value in my calculation. How would you solve this problem? 

[v-yuezhe-msft · Accepted solution]

@tylerbauer,

What formula do you use to calculate YOY revenue? Could you please share sample data of your table?

Besides, take a look at the following blog about how to calculate YOY growth using DAX.
https://sqldusty.com/2015/09/01/10-dax-calculations-for-your-tabular-or-power-pivot-model-part-1/

Regards,