I have a Table using the Financial Reporting w/Power BI as a base to insert the rows and I would like to have a Column to give me the Diff between Actual Sales and Budgeted Sales as a percentage.
I have been able to work out the CurrentItem Variable line but the rest of the lines I cannot get the formula to work the same
This is the DAX I have written down to line 6 works fine I just cannot get the last part to work for the individual lines -
This is my table visualisation
Any help would be greatly apprecaited - I love you content by the way has helped me immensly