Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Vertical analysis

Hello    I am building the financial statements in power bi. and I want to put a vertical analysis column of the income statement groups (income, costs). These groups are made up of accounting acco...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

Anonymous try this:

 

Ingresos = 
CALCULATE(
   SUM(ZF01[Dólares  GyP]), 
   FILTER (  
        ALL (  'Tabla posiciones' ), 
        'Tabla posiciones'[Agrupación]="Ingresos de operación, neto" 
   )
)