Forum Discussion

lmatera's avatar
lmatera
Frequent Visitor
9 years ago
Solved

Variation estimated vs. real

Hi! I need to add a column or measure with the variation between two variables: Data looks like this: Año Categoría año Concepto Subconcepto Departamento Coste 01/01/2017 Real Ban...
Need Help
Datatouille's avatar
Datatouille
Solution Sage
9 years ago

Hi lmatera

 

Try the following measures:

- Total Coste = Sum(YourTable[Coste])

- Real Coste = Calculate ( [Total Coste] , YourTable[Categoría año] = "Real" )

- Estimado Coste = Calculate ( [Total Coste] , YourTable[Categoría año] = "Estimado" )

- Real vs Estimado = [Real Coste] - [Estimado Coste]

 

 

lmatera's avatar
lmatera
Frequent Visitor
9 years ago

Thanks for your quick response, Excelside.

 

I've tried it, but it doesn't work propertly. The Values duplicate the number of columns.

 

I need three columns for each "Departamento":

 

- Estimado 

- Real

- Variation (real vs estimado)

 

Thanks anyway :-)