Ayuda que formula dax

[RominaPressacco]

Buenos días!! Tengo el dato de costos indirectos de un año que deben ser distribuidos en los metros cuadrados vendidos totales de cada uno de los años que tengo en la tabla... Que formula puedo usar para que en la columna me aparezcan los costos indirectos totales de cada uno de los años?

[VahidDM]

Hi @RominaPressacco 

To calculate the total indirect costs for each year distributed over the total square meters sold, you can use the following DAX formula:

IndirectCostsPerYear =
VAR TotalIndirectCosts = [Indirect Costs Amount]  // Replace with your total indirect costs value
VAR TotalSqMetersAllYears = CALCULATE(SUM(YourTable[SquareMetersSold]), ALL(YourTable))
VAR TotalSqMetersThisYear = SUM(YourTable[SquareMetersSold])
RETURN
TotalIndirectCosts * (TotalSqMetersThisYear / TotalSqMetersAllYears)

Explanation:

• TotalIndirectCosts: The total indirect costs amount you want to distribute.
• TotalSqMetersAllYears: The sum of square meters sold across all years.
• TotalSqMetersThisYear: The sum of square meters sold in the current year.
• Calculation: Distributes the total indirect costs proportionally based on the square meters sold in each year.

Note: Replace YourTable with your actual table name and [SquareMetersSold] with the column name that contains the square meters sold data. Also, replace [Indirect Costs Amount] with your indirect costs value.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube