Hi everyone,
Im trying to find the missing numbers for the Number column below:
Each sequence of numbers has a unique name next to it. AB,AC and AD
I need to isolate the missing numbers in these sequences, like 1240, so I can use them in a table.
Serries | Missing Number |
AB | 1240,1249 |
AC | 12359, 12361,12362 |
AD | 222,225,228 |
I´ve tried using generate series and contactenx but I couldn’t get it to work.
Appreciate your help and support 🙂
Thanks,
Hi, I created a small sample dataset based on the values you provided for the series 'AB'. I believe the below is doing what you're after:
One thing to note, this measure will only work if your visual table only has one row per series name (which is what it seemed like you wanted anyway). It can be tweaked to remove filter context then reapply only the filter on series name, let me know if this is needed and I'll take a look. Hope this helps, let me know if you have any issues or further questions.
Hi, I created a small sample dataset based on the values you provided for the series 'AB'. I believe the below is doing what you're after:
One thing to note, this measure will only work if your visual table only has one row per series name (which is what it seemed like you wanted anyway). It can be tweaked to remove filter context then reapply only the filter on series name, let me know if this is needed and I'll take a look. Hope this helps, let me know if you have any issues or further questions.
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
