frequency break (list numbers) How to show gaps greater than +1

[Anonymous]

Hello experts, I have a small problem with a column with invoice numbers. 
The numbers follow each other. See the picture.

However, there may be a break in frequency between these bill numbers. Example 1 2 3 (break) 7 8 9 10 11
How to show gaps greater than +1 
I would like to be able to display these discrepancies when this happens. Can bi power help me do this?

Thank you very much


Charly

[Ashish_Mathur]

Hi,

What exact result are you expecting?

[Anonymous]

hi @Ashish_Mathur ,

I had to identify the breaks in the list for my customer. 

[Ashish_Mathur]

Hi,

Has your problem been solved now?

[Icey · Accepted solution]

Hi @Anonymous ,

Try this:

1. In Power Query Editor, add an Index column.

2. In Report View, create a measure like so:

Is greater than +1 = 
VAR PreviousIndex =
    MAX ( 'Table'[Index] ) - 1
VAR PreviousValue =
    CALCULATE (
        MAX ( 'Table'[Column1] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Index] = PreviousIndex )
    )
VAR Difference =
    MAX ( 'Table'[Column1] ) - PreviousValue
RETURN
    IF ( Difference > 1, 1, 0 )

Best Regards,

Icey

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