Forum Discussion

JVG's avatar
JVG
Frequent Visitor
3 years ago
Solved

Proyectado de bajas de empleados

Hola, espero puedan ayudarme   Quisiera hacer el siguiente calculo en una metrica, ya he intentado de varias maneras pero no he encontrado la manera, tengo una tabla calendario y  mi tabla de regis...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi JVG ,

     

    Please try:

    First, create an index colum:

    Then apply the measure:

    Measure = 
var _a = CALCULATE(AVERAGE('Table'[Column1]),ALL('Table'))
var _b = ADDCOLUMNS(ALL('Table'),"Value",IF(ISBLANK([Column1]),_a,[Column1]))
return TRUNC(SUMX(FILTER(_b,[Index]<=MAX('Table'[Index])),[Value]))

    Final output:

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi JVG ,

 

Please try:

First, create an index colum:

Then apply the measure:

Measure = 
var _a = CALCULATE(AVERAGE('Table'[Column1]),ALL('Table'))
var _b = ADDCOLUMNS(ALL('Table'),"Value",IF(ISBLANK([Column1]),_a,[Column1]))
return TRUNC(SUMX(FILTER(_b,[Index]<=MAX('Table'[Index])),[Value]))

Final output:

Best Regards,

Jianbo Li

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