Forum Discussion

JVG's avatar
JVG
Frequent Visitor
3 years ago

Proyectado gasto

Hola,  Espero puedan ayudarme   Cuento con la siguientes columanas: Mes, Gasto Mensial, Gasto Acumulado, y me gustaria sacar el proyectado como lo muestra la columna Proyectado tomando en cuenta q...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi JVG ,

 

My Sample is as below.

Data model:

Measure:

Accum = CALCULATE(SUM('Table'[Expense]),FILTER(ALL('Month'),'Month'[Month Number]<= MAX('Month'[Month Number])))
Projected = 
( SELECTEDVALUE ( 'Month'[Month Number] ) - 1 )
    * CALCULATE (
        SUM ( 'Table'[Expense] ),
        FILTER ( ALL ( 'Month' ), 'Month'[Month Number] = 2 )
    )
    - ( SELECTEDVALUE ( 'Month'[Month Number] ) - 2 )
        * CALCULATE (
            SUM ( 'Table'[Expense] ),
            FILTER ( ALL ( 'Month' ), 'Month'[Month Number] = 1 )
        )
Projected Accum = SUMX(FILTER(ALL('Month'),'Month'[Month Number]<= MAX('Month'[Month Number])),[Projected])

Result is as below.

 

Best Regards,
Rico Zhou

 

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