Forum Discussion
Solved
Informes Financieros
Hola a todos, estoy construyendo un Informe financiero de pérdidas y ganancias, SAP me arroja los ingresos negativos y deseo generar una medida que me los pase a positivo sin que me afecte la informa...
Hi Carol_oteg,
Instead of multiplying [Total_Movement] by -1 during the calculation itself, why don't add them all first and then check if the sum is negative or not. That way you can use the same measure for income and expenses if you want.
Try:
Income = var _income = SUMX(DIM_ACCOUNTS,IF(DIM_ACCOUNTS[Category]="Operating Income" || DIM_ACCOUNTS[Category]="Non-operational income", [Total_Movements], 0)) return IF(_income<0, _income*-1 ,_income)Works for you? Mark this post as a solution if it does!
Hi Carol_oteg,
Time Intelligence can fail because of the following reasons:
- Date table not marked as Date Table.
- Null/Error Values in Date Column.
- Discontinuous Dates.
- Bidirectional Joins.
Please check these in your model.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
Muchas gracias Shaurya , voy a verificar