cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
M1k3
Regular Visitor

Correlatividad de Asientos

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
Community Support

Re: Correlatividad de Asientos

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." )

Capture.PNG

 

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.

View solution in original post

3 REPLIES 3
Super User II
Super User II

Re: Correlatividad de Asientos

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
Community Support

Re: Correlatividad de Asientos

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." )

Capture.PNG

 

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.

View solution in original post

M1k3
Regular Visitor

Re: Correlatividad de Asientos

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." )

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘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