ytd average

  1. Y

    How to calculate the YTD Average in Power BI

    Hi, I'm very new to Power Bi and I learn that from Youtube. I am stuck with the YTD Average. If it was in Excel, it's easy - =Average (), But, in Power Bi, it's a bit complicate. I have two table, one is custom build calendar table - 445 calendar. And a fact table. The fact table looks...
  2. J

    Rolling YTD average formula help - criteria range

    i have this formula which works to give me an average for an individual week (A3): =IFERROR(AVERAGEIFS(wkly_recap_data_new!$P:$P,wkly_recap_data_new!$AF:$AF,A3,wkly_recap_data_new!$B:$B,A$1,wkly_recap_data_new!$AG:$AG,""),NA()) in the next column i want to get a rolling YTD average, so as i run...
  3. X

    Help with YTD Average formula.

    Hi i'm working on a spreadsheet to show the monthly and YTD averages of Hands per hour/Spins per hour on 3 casino games. the problem i have is my YTD average has DIV/0! error , i want the ytd average to ignore months that haven't been input yet. e.g BJ hands per hour in Jan=70 so at this point...
  4. U

    Calculating YTD average from multiple sheets

    This may be a simple question. How would I run a YTD average across multiple sheets? I have a budget broken down into months with a summary at the end. I can obtain an overall average, but this obviously isn't accurate. Any help would be great!

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top