How to create a column to show duplicates and another column to show missing values

[PowerBiNoob37]

Hi, i wish to have a datatable as a visual to perform quick QAQC checks on data coming in,

Mostly i need it to show duplicates and missing values,

My data currently looks like this

HOLEID	SampleID	FROM	TO
R12345	RZ999001	0	1
R12345	RZ999002	1	2
R12345	RZ999003	2	3
R12345	RZ999004	3	4
R12345	RZ999006	5	6
R12345	RZ999008	7	8
R12345	RZ999009	8	9
R12345	RZ999010	9	10
R12345	RZ999012	11	12
R12345	RZ999013	12	13
R12346	RZ999014	0	1
R12346	RZ999015	1	2
R12346	RZ999016	4	5
R12346	RZ999017	5	6
R12346	RZ999018	6	7
R12347	RZ999019	0	1
R12347	RZ999020	1	2
R12347	RZ999021	2	3
R12347	RZ999023	4	5
R12347	RZ999024	5	6
R12347	RZ999025	6	7
R12347	RZ999026	0	1
R12347	RZ999027	1	2
R12347	RZ999028	2	3
R12347	RZ999029	4	5
R12347	RZ999030	5	6
R12347	RZ999031	6	7
R12347	RZ999032	7	8

however i need it too look like this

HOLEID	SampleID	FROM	TO	Missing	Double
R12345	RZ999001	0	1	No	No
R12345	RZ999002	1	2	No	No
R12345	RZ999003	2	3	No	No
R12345	RZ999004	3	4	No	No
				Yes	No
R12345	RZ999006	5	6	No	No
				Yes	No
R12345	RZ999008	7	8	No	No
R12345	RZ999009	8	9	No	No
R12345	RZ999010	9	10	No	No
				Yes	No
R12345	RZ999012	11	12	No	No
R12345	RZ999013	12	13	No	No
R12346	RZ999014	0	1	No	No
R12346	RZ999015	1	2	No	No
				Yes	No
R12346	RZ999016	4	5	No	No
R12346	RZ999017	5	6	No	No
R12346	RZ999018	6	7	No	No
R12347	RZ999019	0	1	No	Yes
R12347	RZ999020	1	2	No	Yes
R12347	RZ999021	2	3	No	Yes
				Yes	Yes
R12347	RZ999023	4	5	No	Yes
R12347	RZ999024	5	6	No	Yes
R12347	RZ999025	6	7	No	Yes
R12347	RZ999026	0	1	No	Yes
R12347	RZ999027	1	2	No	Yes
				Yes	Yes
R12347	RZ999028	2	3	No	Yes
R12347	RZ999029	4	5	No	Yes
R12347	RZ999030	5	6	No	Yes
R12347	RZ999031	6	7	No	Yes
R12347	RZ999032	7	8	No	Yes

[amitchandak]

@PowerBiNoob37 , create a table till max sequence

seq= generateseries(1,13,1)

Join the value column with to of you table. Then create a visual and use this value column from seq table in place of two and add this measure

measure =

if(isblank(countrows(Table) ,"Yes", "No")

[PowerBiNoob37]

The values and table shown are examples. The true first and last is 1 or can be as high as 1000 or as low as 50.. Its random and decided on the user inputing the data.

Also i can do the if statment however the blanks are not there, ie. the data will look like the first example on the origional post. the second table is how i want it too look if there is an empty. Its a confusing problem thats been taking me days of using every trick i know and i still cant get it too work, however its very important to our QAQC checking