Forum Discussion
Variance and Percentage between MIN MAX Values
Hello PBI Gurus,
Need your assistance on how I can achieve the below be it formulars via Measures or Calculated Columns. The cells on the left is what I have in my PBI model and the grey cells are what I am wanting to achieve with calculation based on filtered averages from the MAX between results eg - Region based on highest $s & Hrs = Variance
Region = Blank is highest $s & Hrs, so the variance between all other regions
My PBI currently looks like the following:
Once again, greatly appreciate your support and assistance with this one
5 Replies
Hey, I would be lucky to help, but I have to admit that I do not fully understand what you are looking for. For this reason, please create sample data in Excel, create sample calculations. Upload the Excel file to onedrive or dropbox and share the link.
Regards,
Tom
Great thanks Tom, attached is spreadsheet - I am after a calculation that will provide the difference between the Regions based off the highest value returned - RegionTechVariance
Please let me know if you have any further questions
Hi,
In range K3:K6, you have taken the denominator as 17138. Where has this figure comes from? Also, data in range B2:H7 looks like data which is already aggregated via formulas (this does not look like the base data). Share the base data (which can be pasted in an Excel workbook) from where this table was built.
