Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Hi,
What exact result are you expecting?
Hi,
Has your problem been solved now?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |