I have a simple table showing values for two different years of data. I want to show the total year to year percentage difference in the last column (YOY % Change) in the total row at the bottom of the table. Here is the table.
In Excel, I would just drop a simple formula in the cell. How do I show the percentage difference between the table column Totals? In effect (JV_tot - JV_tot_17)/JV_tot_17 for the total row?
Thanks for your help. I am obviously new to Power bi.
It did indeed solve the issue and you guessed it, I was using columns instead of measures. I'm very greateful for your prompt response. I am just beginning to understand Power BI, having spent quite some time with PowerQuery and Pivot tables.