Tengo problemas con una formula DAX

[RodolfoGuti]

Dias_Stock_Enero =

VAR __i = 31

VAR __loopTable = GENERATESERIES(1,__i)

VAR __loopTable1 = ADDCOLUMNS(__loopTable,"__i",Date(2020,1,[Value]))

VAR __loopTable2 = ADDCOLUMNS(__loopTable1,"sum",SUMX(FILTER(Query1,[DocDate]<=[__i]),[cantidad]))

VAR __loopTable3 = ADDCOLUMNS(__loopTable2,"cant",COUNTX(FILTER(__loopTable2,[sum]>0),2))

RETURN

COUNTX(__loopTable3,[cant])

Requiero contar los dias en los que el stock fue mayor que Cero. para sacar un promedio simple

ya pude sumar el stock diariamente con la formula:

Inventario_Enero =

VAR __i = 31

VAR __loopTable = GENERATESERIES(1,__i)

VAR __loopTable1 = ADDCOLUMNS(__loopTable,"__i",Date(2020,1,[Value]))

VAR __loopTable2 = ADDCOLUMNS(__loopTable1,"haj",SUMX(FILTER(Query1,[DocDate]<=[__i]),[cantidad]))

RETURN

SUMX(__loopTable2,[haj])

[v-lionel-msft · Accepted solution]

Hi @RodolfoGuti ,

Or like this?

Dias_Stock_Enero =
VAR __i = 31
VAR __loopTable = GENERATESERIES(1,__i)
VAR __loopTable1 = ADDCOLUMNS(__loopTable,"__i",Date(2020,1,[Value]))
VAR __loopTable2 = ADDCOLUMNS(__loopTable1,"sum",SUMX(FILTER(Query1,[DocDate]<=[__i]),[cantidad]))
VAR __loopTable3 = ADDCOLUMNS(__loopTable2,"cant",COUNTX( FILTER(__loopTable2,[sum]>0), [sum]) )
RETURN
SUMX(__loopTable3,[cant])

Best regards,
Lionel Chen

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