Forum Discussion
Computing measures from aggregations
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?
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,
1 Reply
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,