-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ytd average
-
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...- ypurcaro
- Thread
- powerbi dax ytd average ytd total
- Replies: 1
- Forum: Power Tools
-
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...- josh_m
- Thread
- average criteria range ytd average
- Replies: 9
- Forum: Excel Questions
-
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...- xcarl86x
- Thread
- div/0 error formula too many arguments ytd average
- Replies: 6
- Forum: Excel Questions
-
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!- Utahman
- Thread
- ytd average
- Replies: 3
- Forum: Excel Questions
