Forum Discussion
Find missing data in sequency
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.
2 Replies
Anonymous
you can do this in PQ.
pls see the attachment below
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.
