Forum Discussion

edavila's avatar
edavila
Helper II
8 years ago

Averages

is there a way to get the average percentage of these 3 columns in the totals, I dont seem to find a way, I will like to have an average of the YOY growth %, dont know why in the total is getting the...
Show and Tell
edavila's avatar
edavila
Helper II
8 years ago

this is the formula for the cases YOY

YOY Cs Growth % = divide([YTD Cases] - [YTD Cases Prev], [YTD Cases Prev],0)

 

for sales

YoY Growth % = DIVIDE([YTD Sales] - [YTD Sales Prev], [YTD Sales Prev],0)

 

does this help

 

erik_tarnvik's avatar
erik_tarnvik
Solution Specialist
8 years ago

BTW there is probably a way to get the totals to come out the way you want, but you would have to share the definition of all measures used in your definitions above. And any measure used in those measures and so on. 

  • edavila's avatar
    edavila
    Helper II
    8 years ago

    Thanks for your help and do you need to see the pbix or how you cna help me

     

    thanks

    • erik_tarnvik's avatar
      erik_tarnvik
      Solution Specialist
      8 years ago

      Sure that would be ideal. If you can share through OneDrive or DropBox I'll see if I can figure it out. If you don't want to share your data with everyone on the internet, just send me a private message with the url for the data.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi edavila,

      Have you resolved your issue? If you have, welcome to share your solution, so that more people will find workaround easily.

      Best Regards,
      Angelia