cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

Buenas tardes, estaria precisando obtener un filtro que me permita identificar la correlatividad de los asientos.

Caso propuesto: Cuento con asientos contables  el cual son de 900 registros aproximadamente, debo realizar en PBI una manera donde pueda visualizar/obtener o identificar aquellos asientos que tuvieron saltos.

1001

1002

1003

1005 Excepción, salto 1 asiento.

1006

1009 Excepción, salto 2 asientos.

Seria como la función GAPS en ACL

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

Hi @M1k3 ,

We can create a measure as below to work on it.

``````Measure =
VAR currentindex =
MAX ( 'Table'[Index] )
VAR lastindex =
CALCULATE (
MAX ( 'Table'[Index] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] < currentindex )
)
VAR diff = currentindex - lastindex
RETURN
IF ( diff = 1, BLANK (), "Excepción, salto " & diff & " asientos." )
``````

Pbix as attached.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
3 REPLIES 3
Super User II

en el power query, anyde una columna index
en una medida agara el numero corriente

sustrae 1 del indice corriente and usa  LookupValue() para agarrar el numero del recorde precediente
si el diferencia entre los dos numeros is mas que 1, esto da el numero de "saltos"
si quiere hacer un screen-share sobre la problem, me habla

Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!

Community Support

Hi @M1k3 ,

We can create a measure as below to work on it.

``````Measure =
VAR currentindex =
MAX ( 'Table'[Index] )
VAR lastindex =
CALCULATE (
MAX ( 'Table'[Index] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Index] < currentindex )
)
VAR diff = currentindex - lastindex
RETURN
IF ( diff = 1, BLANK (), "Excepción, salto " & diff & " asientos." )
``````

Pbix as attached.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Regular Visitor

Muchisimas gracias! para que me funcione tuve que eliminar el MAX del currentindex

La forma correcta seria sacar el MAX en el currentindex, o si no, estaria tomando el ultimo valor. Ejemplo: si se cuenta con 190 registros, tomaria el registro 190 como mayor.

Measure = VAR currentindex = ( Sheet1[index] ) VAR lastindex = CALCULATE ( MAX ( Sheet1[index] ); FILTER ( ALLSELECTED (Sheet1); Sheet1[index] < currentindex ) ) VAR diff = currentindex - lastindex RETURN IF ( diff = 1; BLANK (); "Excepción, salto " & diff & " asientos." )

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors