Solved: Find missing data in sequency

Anonymous · ‎11-16-2023

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,

Anonymous · ‎11-16-2023

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.

View solution in original post

ryan_mayu · ‎11-16-2023

@Anonymous

you can do this in PQ.

pls see the attachment below

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Anonymous · ‎11-16-2023

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.