Hi Sam, i have downloaded your spreadsheet and PBI file for your last webinar which you did a PNL report. I noticed your fomula for percent difference might be wrong? Or i may have an old copy of the PBI Report.
the photo shows where I am talking about. Should the dax formula for % diff = actuals - actuals ly / actuals? or 1 - (actuals ly - actuals/ actuals ly)
Or am I thinking of this wrong, because there are clear cases of increasing revenue yet showing a decline in %.