I would like to create a trend graph that shows the YoY% growth by the month over the last 12 months. The month should change automatically every Month, for example this month is Aug, so it should show Sept 2018 till Aug 2019.
And the growth should be showing the growth trend to the previous year so: Dec 2018 -> Growth from Dec 2017 and so on.
I have created a YoY% Quick Measure and used this however it shows this error here. How do I solve this?
Value in last 12 month = CALCULATE(SUMX(Table, Table[GP YoY%]), DATESBETWEEN(Period[Txn Month], EDATE(TODAY(), -12), TODAY()))