Hey everyone,
I am trying to add a column at the end that shows the average of the CapEx numbers for the year and hitting a wall…help please!! 
Best,
Daniel
Hi @daniel.new. What’s CapEx? Please provide a work-in-progress PBIX and a mock-up of your desired outcome, both with sample data if it’s easier.
Greg
CapEx = capital expenditures. Basically, the screenshot I provided shows each month of the year with cost values (CapEx) with each row being a client. Below is the DAX creating those values. For some reason, when I’m adding a total column at the end it’s giving me a number around $3,100. You see just by glancing at the very bottom grey row that the average is definitely not $3k, it’s should be closer to $1k.
Unfortunately I’m not able to provide the actual PBIX file, as it violates our compliance policies, being a healthcare organization.
- $ Average CapEx Per Month Per ADC =
VAR AvgCapExNeededToService =
DIVIDE(
SUMX(
factinvoicedetail,
factinvoicedetail[daysinperiod] * factinvoicedetail[nRatelost]), [# Days of Month] )
RETURN
DIVIDE( AvgCapExNeededToService, [# Serviced ADC (Invoice)] )
Hi @daniel.new. No worries about the compliance policies. It would be helpful for the forum members, however, if you create a small sample dataset in Excel and work-in-progress Power BI file to illustrate your issue and your desired outcome.
Greg
Hi @daniel.new, I noticed you didn’t provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.
A perfect initial question includes all of the following:
- A clear explanation of the problem you are experiencing
- A mockup of the results you want to achieve
- Your current work-in-progress PBIX file
- Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)
Check out this thread on Tools and Techniques for Providing PBIX Files with Your Forum Questions
Not completing your data may sometimes cause delay in getting an answer.
Hi @daniel.new, we’ve noticed that no response has been received from you since October 26.
We waited for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details. Due to inactivity, we’ll be tagging this post as Solved.