Hi All,

I tried a few DAX measures/ formulas but my results did not work to calculate the annualized cost of an application as a percent of total cost for all applications.

Example:

700 applications covering 4 year period. So 2800 rows. For each application per year I need the cost of each application as a percentage of total cost of all 700 applications within given year. Basically a weighted average. Please provide example DAX that I can use

Thank you,

Brian